Magnum One

home *** CD-ROM | disk | FTP | other *** search

/ Magnum One / Magnum One (Mid-American Digital) (Disc Manufacturing).iso / d3 / db4less2.arc / DB4ADV.PRN next >

Wrap

Text File | 1990-06-16 | 319.0 KB | 5,914 lines

OPAA E╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E╔═════════════════════════════════════╗F P E║ ADVANCED TECHNIQUES AND PROGRAMMING ║F P E╚═════════════════════════════════════╝F P EThe objective of this course is to provide you with theF P Eskills required to produce multiple file database systems in theF P Emost efficient manner. Some of the more important elements areF P Elisted here.F P ECONDITIONAL SELECTIONF P E▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒F P EAn essential element of advanced system design is theF P Eability to select from the data only information that meetsF P Ecertain conditions.F P EMULTIPLE FILESF P E▒▒▒▒▒▒▒▒▒▒▒▒▒▒F P EAnother powerful tool is the ability to relate more than oneF P Efile together thus providing access to related informationF P Ecollected by different systems.F P EREPORTINGF P E▒▒▒▒▒▒▒▒▒F P EdBase IV allows report and label designs to include theF P Econdition and multiple file features. There is virtually noF P Ereport or label that cannot be produced easily when theseF P Efeatures are combined.F P EDATA VALIDATIONF P E▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒F P EUsing multiple file linking data entries can be easilyF P Evalidated by looking up entries in related files.F P EPROGRAMMINGF P E▒▒▒▒▒▒▒▒▒▒▒F P EThe flow of activity in database systems is controlled byF P Eprogramming. Programming is the use of the dBase language toF P Eproduce the desirable activity flow. This course emphasizes theF P Euse of the applications generator from the Control Center toF P Eproduce the proper programming. Hand coding of programs is stillF P Eallowed in dBase IV, but is not as efficient as the use of theF P Eapplications generator. PEAAF P E┌──────────────────────────────┐F P E│ ELEMENTS OF DATABASE DESIGN │F P E└──────────────────────────────┘F P E┌────────┐F P E│ DEFINE │ ┌─────────┐ ┌─────────┐ ┌─────────┐ ┌─────────┐F P E│ PHASE ├───┤ 1├──┤ 2├──┤ 3├──┤ 4│F P E└───┬────┘ ├─────────┤ ├─────────┤ ├─────────┤ ├─────────┤F P E│ │DETERMINE│ │IDENTIFY │ │ ITEMS │ │ CONFIRM │F P E│ │CUSTOMER │ │ TASKS │ │WORKSHEET│ │ PROCESS │F P E│ │OBJECTIVE│ └─────────┘ └─────────┘ └─────────┘F P E│ └─────────┘F P E┌───┴────┐F P E│ DESIGN │ ┌─────────┐ ┌─────────┐ ┌─────────┐ ┌─────────┐F P E│ PHASE ├───┤ 5├──┤ 6├──┤ 7├──┤ 8│F P E└───┬────┘ ├─────────┤ ├─────────┤ ├─────────┤ ├─────────┤F P E│ │ORGANIZE │ │ FILE │ │DATA FILE│ │ QUERY │F P E│ │ FILES │ │ORDERING │ │WORKSHEET│ │WORKSHEET│F P E│ └─────────┘ └─────────┘ └─────────┘ └────┬────┘F P E│ ┌──────────────────────────────────────┘F P E│ ┌────┴────┐ ┌─────────┐ ┌─────────┐ ┌─────────┐F P E│ │ 9├──┤ 10├──┤ 11├──┤ 12│F P E│ ├─────────┤ ├─────────┤ ├─────────┤ ├─────────┤F P E│ │ FORM │ │ REPORT │ │ LABEL │ │ MENU │F P E│ │WORKSHEET│ │WORKSHEET│ │WORKSHEET│ │WORKSHEET│F P E│ └─────────┘ └─────────┘ └─────────┘ └─────────┘F P E┌───┴────┐F P E│ CREATE │ ┌─────────┐ ┌─────────┐ ┌─────────┐ ┌─────────┐F P E│ PHASE ├───┤ 13├──┤ 14├──┤ 15├──┤ 16│F P E└───┬────┘ ├─────────┤ ├─────────┤ ├─────────┤ ├─────────┤F P E│ │ SYSTEM │ │ DATA │ │ QUERY │ │ SCREEN │F P E│ │ SETUP │ │ FILES │ │ FILES │ │ FORMS │F P E│ └─────────┘ └─────────┘ └─────────┘ └────┬────┘F P E│ ┌──────────────────────────────────────┘F P E│ ┌────┴────┐ ┌─────────┐ ┌─────────┐ ┌─────────┐F P E│ │ 17│ │ 18│ │ 19│ │ 20│F P E│ ├─────────┤ ├─────────┤ ├─────────┤ ├─────────┤F P E│ │ REPORTS │ │ LABELS │ │ FILE │ │ SYSTEM │F P E│ │ │ │ │ │ MENUS │ │ MENUS │F P E│ └─────────┘ └─────────┘ └─────────┘ └─────────┘F P E┌───┴────┐F P E│ USE │ ┌─────────┐ ┌─────────┐ ┌─────────┐ ┌─────────┐F P E│ PHASE ├───┤ 21├──┤ 22├──┤ 23├──┤ 24│F P E└───┬────┘ ├─────────┤ ├─────────┤ ├─────────┤ ├─────────┤F P E│ │ TEST │ │ INSTALL │ │ TRAIN │ │IMPLEMENT│F P E│ │ SYSTEM │ │ │ │ STAFF │ │ SYSTEM │F P E│ └─────────┘ └─────────┘ └─────────┘ └─────────┘F P E┌───┴────┐F P E│ MODIFY │ ┌─────────┐F P E│ PHASE ├───┤ 25│F P E└────────┘ ├─────────┤F P E│ MAKE │F P E│ CHANGES │F P E└─────────┘FA'A' P EPage 2 (c) Interco InternationalPEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E┌──────────────────────────────────┐F P E│ADVANCED QUERIES AND RELATED FILES│F P E└──────────────────────────────────┘F P E┌────────────────────────────────────────────┐F P E│ Ad Hoc Inquiries - Find only what you want │F P E└────────────────────────────────────────────┘F P EAd hoc inquiries are accomplished through the Query DesignF P EPanel of the Control Center. The basic steps for creating queriesF P Eare as follows:F P E1. USE QUERY - Select <create> in the Queries PanelF P Eof Control Center.F P E2. FILES - Press <ALT><L> then <A> to add a file toF P Ethe Query.F P E3. FIELDS - Use <TAB> to move to each field to beF P Eincluded, then press <F5> to add the field.F P E4. LINKS/CONDITIONS - Add conditions, ordering and/orF P Efile linkages.FA*A* A(A( P E(c) Interco International Page 3PEAAF P E┌───────────────────────────────────────────────────────────┐F P E│ QUERY EXAMPLE 1 - EMPLOYEES IN THE PROGRAMMING DEPARTMENT │F P E└───────────────────────────────────────────────────────────┘F P MELayout Fields Condition Update Exit 9:15:12 amF M E┌────────────┬─────────────────────┬─────────────────────┬─────────────────────┐F M E│Emp.dbf │ EMPID │ DEPT │ LNAME │F M E╘════════════╪═════════════════════╪═════════════════════╪═════════════════════F M E│ │'PROG' │ │F M E╓View────────╥───────────────┬───────────────┬───────────────┐F M E║<NEW> ║Emp-> │Emp-> │Emp-> │F M E║ ║DEPT │FNAME │LNAME │F M E╙────────────╨───────────────┴───────────────┴───────────────┘F M EQuery ║D:\...bt4w\<NEW> ║Field 2/13 ║ ║ InsF M EPrev/Next field:Shift-Tab/Tab Data:F2 Pick:Shift-F1 Prev/Next skel:F3/F4F M ERecords Fields Go To Exit 9:15:33 amF M E┌────┬────────────────────┬────────────────────────────────────────────────────┐F M E│DEPT│FNAME │LNAME │F M E╞════╪════════════════════╪════════════════════════════════════════════════════╡F M E│PROG│Kael │Cognac │F M E│PROG│Kevin │Barry │F M E│PROG│Allison │Jonah │F M E│PROG│Holly │Kathleenovitch │F M E│PROG│Jeff │Bonnacker │F M E│PROG│Stuart │Brooks │F M E│PROG│Joseph │Randall │F M E│PROG│Robert │Bruce │F M E│PROG│Blaise │Lacroux │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E└────┴────────────────────┴────────────────────────────────────────────────────┘F M EBrowse ║D:\...bt4w\<NEW> ║Rec 4/18 ║View ║ ║ InsFA*A* M PAAEPage 4 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E┌─────────────────────────────────────────────────────────────┐F P E│ QUERY EXAMPLE 2 - EMPLOYEES IN THE PROG or CORP DEPARTMENTS │F P E└─────────────────────────────────────────────────────────────┘F P MELayout Fields Condition Update Exit 9:16:43 amF M E┌────────────┬─────────────────────┬─────────────────────┬─────────────────────┐F M E│Emp.dbf │ EMPID │ DEPT │ LNAME │F M E╘════════════╪═════════════════════╪═════════════════════╪═════════════════════F M E│ │ │ │F M E╔CONDITION BOX═══════════════╗F M E║DEPT='PROG'.OR.DEPT='CORP' ║F M E║ ║F M E║ ║F M E╚════════════════════════════╝F M E╓View────────╥───────────────┬───────────────┬───────────────┐F M E║<NEW> ║Emp-> │Emp-> │Emp-> │F M E║ ║DEPT │FNAME │LNAME │F M E╙────────────╨───────────────┴───────────────┴───────────────┘F M EQuery ║D:\...bt4w\<NEW> ║Row 1/1 ║ ║ CapsInsF M EPick operators/fields:shift-F1 Data:F2 Zoom:F9 Prev/Next skeleton:F3/F4F M ERecords Fields Go To Exit 9:17:03 amF M E┌────┬────────────────────┬────────────────────────────────────────────────────┐F M E│DEPT│FNAME │LNAME │F M E╞════╪════════════════════╪════════════════════════════════════════════════════╡F M E│CORP│Sally │Middleton │F M E│PROG│Kael │Cognac │F M E│CORP│Jean │Lacroux │F M E│PROG│Kevin │Barry │F M E│PROG│Allison │Jonah │F M E│PROG│Holly │Kathleenovitch │F M E│PROG│Jeff │Bonnacker │F M E│PROG│Stuart │Brooks │F M E│PROG│Joseph │Randall │F M E│PROG│Robert │Bruce │F M E│CORP│Bonnie │Connors │F M E│PROG│Blaise │Lacroux │F M E│CORP│Leigh │Zoellner │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E└────┴────────────────────┴────────────────────────────────────────────────────┘F M EBrowse ║D:\...bt4w\<NEW> ║Rec 3/18 ║View ║ ║ CapsInsFAA M PAAE(c) Interco International Page 5 PEAAF P E┌──────────────────────────────────────────────────────────┐F P E│ QUERY EXAMPLE 3 - COUNT EMPLOYEES IN THE PROG/CORP DEPTS │F P E└──────────────────────────────────────────────────────────┘F P MELayout Fields Condition Update Exit 9:20:34 amF M E┌────────────┬─────────────────────┬─────────────────────┬─────────────────────┐F M E│Emp.dbf │ EMPID │ DEPT │ LNAME │F M E╘════════════╪═════════════════════╪═════════════════════╪═════════════════════F M E│ │COUNT │ │F M E╔CONDITION BOX═══════════════╗F M E║DEPT='PROG'.OR.DEPT='CORP' ║F M E║ ║F M E║ ║F M E╚════════════════════════════╝F M E╓View────────╥───────────────┬───────────────┬───────────────┐F M E║<NEW> ║Emp-> │Emp-> │Emp-> │F M E║ ║DEPT │FNAME │LNAME │F M E╙────────────╨───────────────┴───────────────┴───────────────┘F M EQuery ║D:\...bt4w\<NEW> ║Field 2/13 ║ ReadOnly║ CapsInsF M EPrev/Next field:Shift-Tab/Tab Data:F2 Pick:Shift-F1 Prev/Next skel:F3/F4F M ERecords Fields Go To Exit 9:20:19 amF M E┌────────────────────┬────────────────────┬────────────────────────────────────┐F M E│DEPT │FNAME │LNAME │F M E╞════════════════════╪════════════════════╪════════════════════════════════════╡F M E│ 13.00│ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E└────────────────────┴────────────────────┴────────────────────────────────────┘F M EBrowse ║D:\...bt4w\<NEW> ║Rec 1/1 ║View ║ReadOnly║ CapsInsFAA M PAAEPage 6 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E┌──────────────────────────────────────────────────────────────┐F P E│ QUERY EXAMPLE 4 - EMPLOYEES IN ORDER BY LAST THEN FIRST NAME │F P E└──────────────────────────────────────────────────────────────┘F P MELayout Fields Condition Update Exit 9:25:58 amF M E┌────────────┬─────────────────────┬─────────────────────┬─────────────────────┐F M E│Emp.dbf │ DEPT │ LNAME │ FNAME │F M E╘════════════ ═════════════════════╪═════════════════════╪═════════════════════F M E│ │ASC1 │ASC2 │F M E│ │ │ │F M E╓View────────╥───────────────┬───────────────┐F M E║<NEW> ║Emp-> │Emp-> │F M E║ ║LNAME │FNAME │F M E╙────────────╨───────────────┴───────────────┘F M EQuery ║D:\...bt4w\<NEW> ║Field 4/13 ║ ReadOnly║ CapsInsF M EPrev/Next field:Shift-Tab/Tab Data:F2 Pick:Shift-F1 Prev/Next skel:F3/F4F M ERecords Fields Go To Exit 9:25:43 amF M E┌─────────────────────────┬────────────────────────────────────────────────────┐F M E│LNAME │FNAME │F M E╞═════════════════════════╪════════════════════════════════════════════════════╡F M E│Barry │Kevin │F M E│Bonnacker │Jeff │F M E│Brooks │Stuart │F M E│Bruce │Charles │F M E│Bruce │Robert │F M E│Bryan │Christopher │F M E│Cognac │Kael │F M E│Connors │Bonnie │F M E│Jonah │Allison │F M E│Kathleenovitch │Holly │F M E│Lacroux │Blaise │F M E│Lacroux │Jean │F M E│Marie │Lisa │F M E│Middleton │Sally │F M E│Randall │Joseph │F M E│Ridley │Nell │F M E│Troutman │George │F M E└─────────────────────────┴────────────────────────────────────────────────────┘F M EBrowse ║D:\...bt4w\<NEW> ║Rec 1/18 ║View ║ReadOnly║ CapsInsFAA M PAAE(c) Interco International Page 7 PEAAF P E┌─────────────────────────────────────────────────────────┐F P E│ QUERY EXAMPLE 5 - FIND EMPLOYEE WHOSE LAST NAME SOUNDS │F P E│ LIKE 'bruise' IN ORDER BY LAST NAME │F P E└─────────────────────────────────────────────────────────┘F P MELayout Fields Condition Update Exit 9:35:20 amF M E┌────────────┬─────────────────────┬─────────────────────┬─────────────────────┐F M E│Emp.dbf │ DEPT │ LNAME │ FNAME │F M E╘════════════ ═════════════════════╪═════════════════════╪═════════════════════F M EFIND │ │SOUNDS LIKE 'BRUISE' │ │F M E│ │ASC1 │ │F M E╓View────────╥───────────────┬───────────────┐F M E║<NEW> ║Emp-> │Emp-> │F M E║ ║LNAME │FNAME │F M E╙────────────╨───────────────┴───────────────┘F M EQuery ║D:\...bt4w\<NEW> ║Field 3/13 ║ ║ CapsInsF M EPrev/Next field:Shift-Tab/Tab Data:F2 Pick:Shift-F1 Prev/Next skel:F3/F4F M ERecords Fields Go To Exit 9:35:48 amF M E┌─────────────────────────┬────────────────────────────────────────────────────┐F M E│LNAME │FNAME │F M E╞═════════════════════════╪════════════════════════════════════════════════════╡F M E│Brooks │Stuart │F M E│Bruce │Charles │F M E│Bruce │Robert │F M E│Bryan │Christopher │F M E│Cognac │Kael │F M E│Connors │Bonnie │F M E│Jonah │Allison │F M E│Kathleenovitch │Holly │F M E│Lacroux │Jean │F M E│Lacroux │Blaise │F M E│Marie │Lisa │F M E│Middleton │Sally │F M E│Randall │Joseph │F M E│Ridley │Nell │F M E│Troutman │George │F M E│Zoellner │Leigh │F M E│ │ │F M E└─────────────────────────┴────────────────────────────────────────────────────┘F M EBrowse ║D:\...bt4w\<NEW> ║Rec 12/18 ║View ║ ║ CapsInsFA*A* M PAAEPage 8 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E┌───────────────────────────────────────────────────────┐F P E│ QUERY EXAMPLE 6 - WHOSE LAST NAME CONTAINS 'ro' │F P E│ IN ORDER BY LAST NAME │F P E└───────────────────────────────────────────────────────┘F P MELayout Fields Condition Update Exit 9:37:22 amF M E┌────────────┬─────────────────────┬─────────────────────┬─────────────────────┐F M E│Emp.dbf │ EMPID │ DEPT │ LNAME │F M E╘════════════╪═════════════════════╪═════════════════════╪═════════════════════F M E│ │ │$'ro' │F M E│ │ │ASC1 │F M E╓View────────╥───────────────┬───────────────┐F M E║<NEW> ║Emp-> │Emp-> │F M E║ ║LNAME │FNAME │F M E╙────────────╨───────────────┴───────────────┘F M EQuery ║D:\...bt4w\<NEW> ║File 1/1 ║ ║ CapsInsF M ENext field:Tab Add/Remove all fields:F5 Zoom:F9 Prev/Next skeleton:F3/F4F M ERecords Fields Go To Exit 9:37:48 amF M E┌─────────────────────────┬────────────────────────────────────────────────────┐F M E│LNAME │FNAME │F M E╞═════════════════════════╪════════════════════════════════════════════════════╡F M E│Brooks │Stuart │F M E│Lacroux │Jean │F M E│Lacroux │Blaise │F M E│Troutman │George │F M E│ │ │F M E│ │ │F M E│ │ │F M E│ │ │F M E│ │ │F M E│ │ │F M E│ │ │F M E│ │ │F M E│ │ │F M E│ │ │F M E│ │ │F M E│ │ │F M E│ │ │F M E└─────────────────────────┴────────────────────────────────────────────────────┘F M EBrowse ║D:\...bt4w\<NEW> ║Rec 12/18 ║View ║ ║ CapsInsFA*A* M PAAE(c) Interco International Page 9 PEAAF P E┌──────────────────────────────────────────────────────────┐F P E│ QUERY EXAMPLE 7 - TIMESLIP HOURS FOR FUNCTION CODE │F P E│ LIKE '03*' │F P E└──────────────────────────────────────────────────────────┘F P MELayout Fields Condition Update Exit 9:30:45 amF M E┌────────────┬─────────────────────┬─────────────────────┬─────────────────────┐F M E│Time.dbf │ DATE │ HOURS │ FUNCODE │F M E╘════════════╪═════════════════════╪═════════════════════╪═════════════════════F M E│ │SUM │LIKE '03*' │F M E╓View────────╥───────────────┬───────────────┬───────────────┐F M E║<NEW> ║Time-> │Time-> │Time-> │F M E║ ║JOBID │HOURS │FUNCODE │F M E╙────────────╨───────────────┴───────────────┴───────────────┘F M EQuery ║D:\...bt4w\<NEW> ║Field 3/5 ║ ReadOnly║ CapsInsF M EPrev/Next field:Shift-Tab/Tab Data:F2 Pick:Shift-F1 Prev/Next skel:F3/F4F M ERecords Fields Go To Exit 9:31:14 amF M E┌─────┬──────┬─────────────────────────────────────────────────────────────────┐F M E│JOBID│HOURS │FUNCODE │F M E╞═════╪══════╪═════════════════════════════════════════════════════════════════╡F M E│ │279.00│ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E└─────┴──────┴─────────────────────────────────────────────────────────────────┘F M EBrowse ║D:\...bt4w\<NEW> ║Rec 1/1 ║View ║ReadOnly║ CapsInsFA*A* M PAAEPage 10 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E┌─────────────────────┐F P E│ MULTIPLE FILE LINKS │F P E└─────────────────────┘F P EFrom the data file chart for the Job Cost System shown belowF P Eseveral situations exist where we might want to retrieveF P Einformation from more than one file at a time. Suppose we want toF P Esee the date, hours and employee's name for all timeslips in aF P Ereport. The date and hours are contained in TIME.DBF, but theF P Eemployee's name is contained in EMP.DBF.F P ETo get information from more than one file at a time weF P Eprovide a linkage between the files. The linkage is ordinarily aF P Ecommon field. To link TIME.DBF to EMP.DBF we would use the field,F P EEMPID which is common to both files. Once linked information fromF P Eboth files can be used in retrieval functions such as reports andF P Elabels.F P E┌─────────────────┐F P E│ JOB COST SYSTEM │F P E└────────┬────────┘F P E┌─────┬────────┬────┴┬────────┬──────────────┐F P E│ │ │ │ │ │F P E┌────┴───┐ │ ┌────┴───┐ │ ┌────┴───┐ ┌────┴───┐F P E┌┴───────┐│ │ ┌┴───────┐│ │ ┌┴───────┐│ ┌┴───────┐│F P E│ ││ │ │ ││ │ │ ││ │ ││F P E│EMPLOYEE││ │ │ TIME ││ │ │ JOB ││ │CUSTOMER││F P E│ ││ │ │ ││ │ │ ││ │ ││F P E│ INFO ││ │ │ SLIPS ││ │ │ INFO ││ │ INFO ││F P E│ ││ │ │ ││ │ │ ││ │ ││F P E│ ││ │ │ INFO ││ │ │ ││ │ ││F P E│ ││ │ │ ││ │ │ ││ │ ││F P E├────────┤│ │ ├────────┤│ │ │ ││ │ ││F P E│ EMPID ├┘ │ │ EMPID ├┘ │ │ ├┘ │ ├┘F P E└───╥────┘ │ └───╥────┘ │ └────────┘ └────────┘F P E╚═══════╪══════╝ │F P E┌──────┴─┐ ┌───────┴─┐F P E┌┴───────┐│ ┌┴────────┐│F P E│EMPLOYEE││ │FUNCTION ││F P E│ ││ │ ││F P E│PAY INFO││ │CODE INFO││F P E│ ├┘ │ ├┘F P E└────────┘ └─────────┘FA%A% P E(c) Interco International Page 11PEAAF P E┌─────────────────────────────────────────────────────────────┐F P E│ QUERY EXAMPLE 8 - EMP AND EMPRATE. SHOW DEPT,NAME AND │F P E│ PAYRATE │F P E└─────────────────────────────────────────────────────────────┘F P MELayout Fields Condition Update Exit 9:42:22 amF M E┌────────────┬─────────────────────┬─────────────────────┬─────────────────────┐F M E│Emp.dbf │ EMPID │ DEPT │ LNAME │F M E╘════════════╪═════════════════════╪═════════════════════╪═════════════════════F M E│LINK1 │ │ │F M E┌────────────┬─────────────────────┬─────────────────────┬─────────────────────┐F M E│Emprate.dbf │ EMPID │ RATE │ RATEDATE │F M E╘════════════╪═════════════════════╪═════════════════════╪═════════════════════╡F M E│LINK1 │ │ │F M E╓View────────╥───────────────┬───────────────┬───────────────┬───────────────┐F M E║<NEW> ║Emp-> │Emp-> │Emp-> │Emprate-> │F M E║ ║DEPT │LNAME │FNAME │RATE │F M E╙────────────╨───────────────┴───────────────┴───────────────┴───────────────┘F M EQuery ║D:\...bt4w\<NEW> ║File 1/2 ║ ReadOnly║ CapsInsF M ENext field:Tab Add/Remove all fields:F5 Zoom:F9 Prev/Next skeleton:F3/F4F M ERecords Fields Go To Exit 9:42:03 amF M E┌────┬─────────────────────────┬────────────────────┬──────────────────────────┐F M E│DEPT│LNAME │FNAME │RATE │F M E╞════╪═════════════════════════╪════════════════════╪══════════════════════════╡F M E│MIS │Bruce │Charles │ 55.00 │F M E│WORD│Marie │Lisa │ 25.00 │F M E│CORP│Middleton │Sally │ 50.00 │F M E│PROG│Cognac │Kael │ 35.00 │F M E│CORP│Lacroux │Jean │ 50.00 │F M E│MIS │Troutman │George │ 50.00 │F M E│PROG│Barry │Kevin │ 60.00 │F M E│WORD│Bryan │Christopher │ 25.00 │F M E│PROG│Jonah │Allison │ 40.00 │F M E│PROG│Kathleenovitch │Holly │ 50.00 │F M E│PROG│Bonnacker │Jeff │ 40.00 │F M E│PROG│Brooks │Stuart │ 50.00 │F M E│PROG│Randall │Joseph │ 50.00 │F M E│PROG│Bruce │Robert │ 65.00 │F M E│CORP│Connors │Bonnie │ 60.00 │F M E│PROG│Lacroux │Blaise │ 35.00 │F M E│CORP│Zoellner │Leigh │ 50.00 │F M E└────┴─────────────────────────┴────────────────────┴──────────────────────────┘F M EBrowse ║D:\...bt4w\<NEW> ║Rec 1/18 ║View ║ReadOnly║ CapsInsFA*A* M PAAEPage 12 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E┌───────────────────────────────────────────────────────────┐F P E│ QUERY EXAMPLE 9 - TIME, EMP AND EMPRATE. SHOW DEPT, │F P E│ NAME, HOURS AND PAYRATE IN ORDER │F P E│ BY LAST NAME │F P E└───────────────────────────────────────────────────────────┘F P MELayout Fields Condition Update Exit 9:49:40 amF M E┌────────────┬─────────────────────┬─────────────────────┬─────────────────────┐F M E│Time.dbf │ HOURS │ FUNCODE │ EMPID │F M E╘════════════ ═════════════════════╪═════════════════════╪═════════════════════F M E│ │ │LINK1 │F M E┌────────────┬─────────────────────┬─────────────────────┬─────────────────────┐F M E│Emp.dbf │ EMPID │ DEPT │ LNAME │F M E╘════════════╪═════════════════════╪═════════════════════╪═════════════════════F M E│LINK1 │ │ASC2 │F M E┌────────────┬─────────────────────┬─────────────────────┬─────────────────────┐F M E│Emprate.dbf │ EMPID │ RATE │ RATEDATE │F M E╘════════════╪═════════════════════╪═════════════════════╪═════════════════════╡F M E│LINK1 │ │ │F M E╓View────────╥───────────────┬───────────────┬───────────────┬───────────────┐F M E║<NEW> ║Time-> │Emp-> │Time-> │Emprate-> │F M E║ ║DATE │LNAME │HOURS │RATE │F M E╙────────────╨───────────────┴───────────────┴───────────────┴───────────────┘F M EQuery ║D:\...bt4w\<NEW> ║Field 3/13 ║ ReadOnly║ CapsInsF M EPrev/Next field:Shift-Tab/Tab Data:F2 Pick:Shift-F1 Prev/Next skel:F3/F4F M ERecords Fields Go To Exit 9:50:13 amF M E┌────────┬─────────────────────────┬──────┬────────────────────────────────────┐F M E│DATE │LNAME │HOURS │RATE │F M E╞════════╪═════════════════════════╪══════╪════════════════════════════════════╡F M E│01/06/89│Barry │ 20.00│ 60.00 │F M E│01/06/89│Bonnacker │ 31.00│ 40.00 │F M E│01/06/89│Brooks │ 16.00│ 50.00 │F M E│01/06/89│Bruce │ 12.00│ 55.00 │F M E│01/06/89│Bruce │ 22.00│ 65.00 │F M E│01/06/89│Bruce │ 7.00│ 55.00 │F M E│01/06/89│Bryan │ 14.00│ 25.00 │F M E│01/06/89│Cognac │ 24.00│ 35.00 │F M E│01/06/89│Connors │ 20.00│ 60.00 │F M E│01/06/89│Jonah │ 18.00│ 40.00 │F M E│01/06/89│Kathleenovitch │ 19.00│ 50.00 │F M E│01/06/89│Lacroux │ 22.00│ 50.00 │F M E│01/06/89│Lacroux │ 25.00│ 35.00 │F M E│01/06/89│Marie │ 22.00│ 25.00 │F M E│01/06/89│Middleton │ 20.00│ 50.00 │F M E│01/06/89│Randall │ 16.00│ 50.00 │F M E│01/06/89│Ridley │ 23.00│ 45.00 │F M E└────────┴─────────────────────────┴──────┴────────────────────────────────────┘F M EBrowse ║D:\...bt4w\<NEW> ║Rec 1/82 ║View ║ReadOnly║ CapsInsFAA M PAAE(c) Interco International Page 13 PEAAF P E┌───────────────────────────────────────────────────────────────┐F P E│ QUERY EXAMPLE 10 - LINK TIME, EMP AND EMPRATE. SHOW DEPT, │F P E│ NAME, HOURS, PAYRATE CALCULATE BILLING │F P E│ IN ORDER BY LAST NAME │F P E└───────────────────────────────────────────────────────────────┘F P MELayout Fields Condition Update Exit 9:53:25 amF M E┌────────────┬─────────────────────┬─────────────────────┬─────────────────────┐F M E│Emp.dbf │ EMPID │ DEPT │ LNAME │F M E╘════════════╪═════════════════════╪═════════════════════╪═════════════════════F M E│LINK1 │ │ASC2 │F M E┌────────────┬─────────────────────┬─────────────────────┬─────────────────────┐F M E│Emprate.dbf │ EMPID │ RATE │ RATEDATE │F M E╘════════════╪═════════════════════╪═════════════════════╪═════════════════════╡F M E│LINK1 │ │ │F M E┌────────────┬BILLING=─────────────┐F M E│Calc'd Flds │ HOURS*RATE │F M E╘════════════╪═════════════════════╡F M E│ │F M E╓View────────╥───────────────┬───────────────┬───────────────┬BILLING=───────┐F M E║<NEW> ║Emp-> │Time-> │Emprate-> │Calc'd Flds-> │F M E║ ║LNAME │HOURS │RATE │HOURS*RATE │F M E╙──────────── ───────────────┴───────────────┴───────────────┴───────────────┘F M EQuery ║D:\...bt4w\<NEW> ║Field 1/1 ║ ReadOnly║ CapsInsF M EPrev/Next field:Shift-Tab/Tab Data:F2 Pick:Shift-F1 Prev/Next skel:F3/F4F M ERecords Fields Go To Exit 9:53:03 amF M E┌────────┬─────────────────────────┬──────┬──────┬─────────────────────────────┐F M E│DATE │LNAME │HOURS │RATE │BILLING │F M E╞════════╪═════════════════════════╪══════╪══════╪═════════════════════════════╡F M E│01/06/89│Barry │ 20.00│ 60.00│ 1200.00 │F M E│01/06/89│Bonnacker │ 31.00│ 40.00│ 1240.00 │F M E│01/06/89│Brooks │ 16.00│ 50.00│ 800.00 │F M E│01/06/88│Bruce │ 12.00│ 55.00│ 660.00 │F M E│01/06/89│Bruce │ 22.00│ 65.00│ 1430.00 │F M E│01/06/89│Bruce │ 7.00│ 55.00│ 385.00 │F M E│01/06/89│Bryan │ 14.00│ 25.00│ 350.00 │F M E│01/06/89│Cognac │ 24.00│ 35.00│ 840.00 │F M E│01/06/89│Connors │ 20.00│ 60.00│ 1200.00 │F M E│01/06/89│Jonah │ 18.00│ 40.00│ 720.00 │F M E│01/06/89│Kathleenovitch │ 19.00│ 50.00│ 950.00 │F M E│01/06/89│Lacroux │ 22.00│ 50.00│ 1100.00 │F M E│01/06/89│Lacroux │ 25.00│ 35.00│ 875.00 │F M E│01/06/89│Marie │ 22.00│ 25.00│ 550.00 │F M E│01/06/89│Middleton │ 20.00│ 50.00│ 1000.00 │F M E│01/06/89│Randall │ 16.00│ 50.00│ 800.00 │F M E│01/06/89│Ridley │ 23.00│ 45.00│ 1035.00 │F M E└────────┴─────────────────────────┴──────┴──────┴─────────────────────────────┘F M EBrowse ║D:\...bt4w\<NEW> ║Rec 1/82 ║View ║ReadOnly║ CapsInsFAA M PAAEPage 14 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E┌──────────────────────────────────────────────────────────────┐F P E│ QUERY EXAMPLE 11 - LINK TIME AND FUNCODE. SHOW JOBID, DESC, │F P E│ DATE AND HOURS IN ORDER BY JOBID, │F P E│ FUNCTION CODE AND DATE │F P E└──────────────────────────────────────────────────────────────┘F P MELayout Fields Condition Update Exit 10:15:47 amF M E┌────────────┬─────────────────────┬─────────────────────┬─────────────────────┐F M E│Time.dbf │ DATE │ HOURS │ FUNCODE │F M E╘════════════╪═════════════════════╪═════════════════════╪═════════════════════F M E│ASC3 │ │LINK1 │F M E┌────────────┬─────────────────────┬─────────────────────┐F M E│Funcode.dbf │ FUNCODE │ FUNDESC │F M E╘════════════╪═════════════════════╪═════════════════════╡F M E│LINK1,ASC2 │ │F M E╓View────────╥───────────────┬───────────────┬───────────────┬───────────────┐F M E║<NEW> ║Time-> │Funcode-> │Time-> │Time-> │F M E║ ║JOBID │FUNDESC │HOURS │DATE │F M E╙────────────╨───────────────┴───────────────┴───────────────┴───────────────┘F M EQuery ║D:\...bt4w\<NEW> ║Field 1/5 ║ ReadOnly║ CapsInsF M EPrev/Next field:Shift-Tab/Tab Data:F2 Pick:Shift-F1 Prev/Next skel:F3/F4F M ERecords Fields Go To Exit 10:15:06 amF M E┌─────┬───────────────────────────────────┬──────┬─────────────────────────────┐F M E│JOBID│FUNDESC │HOURS │DATE │F M E╞═════╪═══════════════════════════════════╪══════╪═════════════════════════════╡F M E│BOI01│A. Define System Concept │ 20.00│01/06/89 │F M E│BOI01│A. Define System Concept │ 22.00│01/06/89 │F M E│BOI01│A. Define System Concept │ 10.00│01/13/89 │F M E│BOI01│A. Define System Concept │ 20.00│01/20/89 │F M E│BOI01│A. Define System Concept │ 22.00│01/20/89 │F M E│BOI01│A. Define System Concept │ 10.00│01/27/89 │F M E│BOI01│B. System Design │ 13.00│01/13/89 │F M E│BOI01│B. System Design │ 13.00│01/27/89 │F M E│BOI01│C. Create System with dBase IV │ 14.00│01/06/89 │F M E│BOI01│C. Create System with dBase IV │ 14.00│01/13/89 │F M E│BOI01│C. Create System with dBase IV │ 14.00│01/27/89 │F M E│BOI01│D. Install and Work with Users │ 16.00│01/06/89 │F M E│BOI01│D. Install and Work with Users │ 12.00│01/13/89 │F M E│BOI01│D. Install and Work with Users │ 16.00│01/20/89 │F M E│BOI01│D. Install and Work with Users │ 14.00│01/20/89 │F M E│BOI01│D. Install and Work with Users │ 12.00│01/27/89 │F M E│BOI01│E. Make Modifications to System │ 22.00│01/06/89 │F M E└─────┴───────────────────────────────────┴──────┴─────────────────────────────┘F M EBrowse ║D:\...bt4w\<NEW> ║Rec 1/82 ║View ║ReadOnly║ CapsInsFAA M PAAE(c) Interco International Page 15 PEAAF P E┌───────────────────────────────────────────────────────────────┐F P E│ QUERY EXAMPLE 12 - TIME AND FUNCODE. SHOW JOBID, DESC, AND │F P E│ HOURS IN ORDER BY JOBID, FUNCTION CODE. │F P E│ SUM HOURS GROUPED BY JOBID AND │F P E│ FUNCTION DESCRIPTION. │F P E└───────────────────────────────────────────────────────────────┘F P MELayout Fields Condition Update Exit 10:24:00 amF M E┌────────────┬─────────────────────┬─────────────────────┬─────────────────────┐F M E│Time.dbf │ FUNCODE │ EMPID │ JOBID │F M E╘════════════ ═════════════════════╪═════════════════════╪═════════════════════╡F M E│LINK1 │ │GROUP BY,ASC1 │F M E┌────────────┬─────────────────────┬─────────────────────┐F M E│Funcode.dbf │ FUNCODE │ FUNDESC │F M E╘════════════╪═════════════════════╪═════════════════════╡F M E│LINK1 │GROUP BY,ASC2 │F M E╓View────────╥───────────────┬───────────────┬───────────────┐F M E║T ║Time-> │Funcode-> │Time-> │F M E║ ║JOBID │FUNDESC │HOURS │F M E╙────────────╨───────────────┴───────────────┴───────────────┘F M EQuery ║D:\dbsys\classes\bt4w\T ║Field 5/5 ║ ReadOnly║ CapsInsF M EPrev/Next field:Shift-Tab/Tab Data:F2 Pick:Shift-F1 Prev/Next skel:F3/F4F M ERecords Fields Go To Exit 10:23:33 amF M E┌─────┬───────────────────────────────────┬────────────────────────────────────┐F M E│JOBID│FUNDESC │HOURS │F M E╞═════╪═══════════════════════════════════╪════════════════════════════════════╡F M E│BOI01│A. Define System Concept │104.00 │F M E│BOI01│B. System Design │ 26.00 │F M E│BOI01│C. Create System with dBase IV │ 42.00 │F M E│BOI01│D. Install and Work with Users │ 70.00 │F M E│BOI01│E. Make Modifications to System │ 74.00 │F M E│BRI01│A. Define System Concept │144.00 │F M E│BRI01│B. System Design │ 95.00 │F M E│BRI01│C. Create System with dBase IV │110.00 │F M E│BRI01│D. Install and Work with Users │ 64.00 │F M E│BRI01│E. Make Modifications to System │ 36.00 │F M E│BRI02│A. Define System Concept │ 36.00 │F M E│BRI02│B. System Design │ 21.00 │F M E│BRI02│C. Create System with dBase IV │ 21.00 │F M E│BRI02│D. Install and Work with Users │ 13.00 │F M E│GSA01│A. Define System Concept │ 38.00 │F M E│GSA01│B. System Design │ 46.00 │F M E│GSA01│C. Create System with dBase IV │ 16.00 │F M E└─────┴───────────────────────────────────┴────────────────────────────────────┘F M EBrowse ║D:\dbsys\classes\bt4w\T ║Rec 1/30 ║View ║ReadOnly║ CapsInsFAA M PAAEPage 16 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E┌────────────────────────────────────────────────────────────┐F P E│ QUERY EXAMPLE 13 - TIME AND JOB. SHOW DESC, HOURS AND │F P E│ RATE IN ORDER BY DESCRIPTION. SUM │F P E│ HOURS AND AVG RATE GROUPED BY │F P E│ DESCRIPTION. │F P E└────────────────────────────────────────────────────────────┘F P MELayout Fields Condition Update Exit 10:47:28 amF M E┌────────────┬─────────────────────┬─────────────────────┬─────────────────────┐F M E│Time.dbf │ HOURS │ FUNCODE │ EMPID │F M E╘════════════ ═════════════════════╪═════════════════════╪═════════════════════F M E│SUM │ │LINK2 │F M E┌────────────┬─────────────────────┬─────────────────────┬─────────────────────┐F M E│Job.dbf │ JOBID │ JOBDESC │ CUSTCODE │F M E╘════════════╪═════════════════════╪═════════════════════╪═════════════════════F M E│LINK1 │GROUP BY,ASC1 │ │F M E┌────────────┬─────────────────────┬─────────────────────┬─────────────────────┐F M E│Emprate.dbf │ EMPID │ RATE │ RATEDATE │F M E╘════════════╪═════════════════════╪═════════════════════╪═════════════════════╡F M E│LINK2 │AVG │ │F M E╓View────────╥───────────────┬───────────────┬───────────────┐F M E║T ║Job-> │Time-> │Emprate-> │F M E║ ║JOBDESC │HOURS │RATE │F M E╙────────────╨───────────────┴───────────────┴───────────────┘F M EQuery ║D:\dbsys\classes\bt4w\T ║Field 2/5 ║ ReadOnly║ CapsInsF M EPrev/Next field:Shift-Tab/Tab Data:F2 Pick:Shift-F1 Prev/Next skel:F3/F4F M ERecords Fields Go To Exit 10:48:05 amF M E┌──────────────────────────────────────────────────┬──────┬────────────────────┐F M E│JOBDESC │HOURS │RATE │F M E╞══════════════════════════════════════════════════╪══════╪════════════════════╡F M E│Accounting Program │104.00│ 52.50 │F M E│Catalog For Photographs │100.00│ 45.00 │F M E│Class Scheduling Program │100.00│ 40.00 │F M E│Job Costing System │154.00│ 37.50 │F M E│Network for Pulp Mill │316.00│ 50.00 │F M E│Sales Force Mail File │449.00│ 48.70 │F M E│Tenant Tracking │ 91.00│ 50.00 │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E│ │ │ │F M E└──────────────────────────────────────────────────┴──────┴────────────────────┘F M EBrowse ║D:\dbsys\classes\bt4w\T ║Rec 1/7 ║View ║ReadOnly║ CapsInsFAA M PAAE(c) Interco International Page 17 PEAAF P E┌──────────────────────────────────────────────────────┐F P E│ QUERY EXAMPLE 14 - EMP FILE BY MARKING INACTIVE │F P E│ EMPLOYEES FOR DELETION. │F P E└──────────────────────────────────────────────────────┘F P MELayout Fields Condition Update Exit 11:24:34 amF M E┌─Target─────┬─────────────────────┬─────────────────────┬─────────────────────┐F M E│Emp.dbf │ ZIP │ EMPDATE │ ACTIVE │F M E╘════════════ ═════════════════════╪═════════════════════╪═════════════════════F M EMark │ │ │.F. │F M EQuery ║D:\...classes\bt4w\MARK ║Field 10/13 ║ ║ InsF M EPrev/Next field:Shift-Tab/Tab Data:F2 Pick:Shift-F1 Prev/Next skel:F3/F4F M E┌───────────────────────────────────────────────────┐F M E│ QUERY EXAMPLE 15 - EMP FILE BY UNMARKING ALL │F M E│ EMPLOYEES. │F M E└───────────────────────────────────────────────────┘F M ELayout Fields Condition Update Exit 11:21:09 amF M E┌─Target─────┬─────────────────────┬─────────────────────┬─────────────────────┐F M E│Emp.dbf │ EMPID │ DEPT │ LNAME │F M E╘════════════╪═════════════════════╪═════════════════════╪═════════════════════F M EUnmark │ │ │ │F M EQuery ║D:\...bt4w\UNMARK ║Field 2/13 ║ ║ InsF M EPrev/Next field:Shift-Tab/Tab Data:F2 Pick:Shift-F1 Prev/Next skel:F3/F4FA'A' M PAAEPage 18 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E┌───────────────────────────────┐F P E│ MULTIPLE FILE REPORT CREATION │F P E└───────────────────────────────┘F P E┌──────────────────────┐F P E│ Custom Report Design │F P E└──────────────────────┘F P EAs we have seen information from many files (up to 10) canF P Ebe selected by using the Queries Panel from the Control Center.F P EBy using the Reports Panel in conjunction with Queries we canF P Ecreate elaborate reports with the minimum of effort and withoutF P Eyears of programming experience.F P EThe following examples and report samples show the use ofF P Ethe report writer's many features. Some basic concepts are:F P E┌──────────┐F P E│ Grouping │F P E└──────────┘F P EGrouping assumes that you have ordered the information beingF P Eretrieved by means of selecting an index or the ASC/DSC functionsF P Eof Queries. To the report writer grouping means to subtotal,F P Etotal or page break whenever the group item changes.F P E┌────────────────────┐F P E│ Working with Bands │F P E└────────────────────┘F P EBands are used to define sections of a report. For exampleF P Ethe Title Band should contain the information that you wish toF P Ehave printed on the Title Page of your report. Band descriptionsF P Efollow:F P E┌────────┐F P E│ Title │F P E└────────┘F P EWhat gets printed on the Title Page of a report.F P E┌─────────┐F P E│ Header │F P E└─────────┘F P EPage Header - What gets printed at the top ofF P Eeach page.F P EGroup Header - What gets printed before a groupingF P Ewhen a group expression changes.F P E┌──────┐F P E│ Body │F P E└──────┘F P EWhat gets printed for each record in a report.FAA P E(c) Interco International Page 19PEAAF P E┌─────────┐F P E│ Footer │F P E└─────────┘F P EPage Footer - What gets printed on the bottom ofF P Eeach page.F P EGroup Footer - What gets printed after a groupingF P Ewhen a group expression changes.F P E┌──────────┐F P E│ Summary │F P E└──────────┘F P EWhat gets printed at the bottom of the last pageF P Eof a report.FA*A* A)A) P EPage 20 (c) Interco InternationalPEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E┌─────────────────────────────────┐F P E│ REPORT EXAMPLE 1 - INVOICES │F P E└─────────────────────────────────┘F P EThe Query INVOICE.qbe has been created to relate files andF P Eselect the fields to be used in the report. The partial layout ofF P EINVOICE.qbe is shown here.F P MELayout Fields Condition Update Exit 2:57:29 pmF M E┌────────────┬─────────────────────┬─────────────────────┬─────────────────────┐F M E│Time.dbf │ DATE │# EMPID │# JOBID │F M E╘════════════╪═════════════════════╪═════════════════════╪═════════════════════F M E│ │ │LINK1 │F M E┌────────────┬─────────────────────┬─────────────────────┬─────────────────────┐F M E│Job.dbf │# JOBID │# JOBDESC │# CUSTCODE │F M E╘════════════╪═════════════════════╪═════════════════════╪═════════════════════F M E│LINK1 │ │LINK3 │F M E┌────────────┬─────────────────────┬─────────────────────┐F M E│Funcode.dbf │# FUNCODE │# FUNDESC │F M E╘════════════╪═════════════════════╪═════════════════════╡F M E│LINK2 │ │F M E┌────────────┬─────────────────────┬─────────────────────┬─────────────────────┐F M E│Customer.dbf│# CUSTCODE │# CUSTNAME │ ADDRESS │F M E╘════════════╪═════════════════════╪═════════════════════╪═════════════════════F M E│LINK3 │ │ │F M E╓View────────╥───────────────┬───────────────┬───────────────┬───────────────┐F M E║Untitled ║Customer-> │Customer-> │Customer-> │Customer-> │F M E║ ║ADDRESS │CITY │STATE │ZIP │F M E╙──────────── ───────────────┴───────────────┴───────────────┴───────────────┘F M EQuery ║D:\...bt4\INVOICE ║File 4/4 ║ ║ CapsF M ENext field:Tab Add/Remove all fields:F5 Zoom:F9 Prev/Next skeleton:F3/F4FA*A* A(A( M PAAE(c) Interco International Page 21 PEAAF P E┌───────────────────────────────────────┐F P E│ REPORT DESIGN SCREEN - INVOICE REPORT │F P E└───────────────────────────────────────┘F P MEReport Intro Band──────────────────────────────────────────────────────────F M EPage Header Band──────────────────────────────────────────────────────────F M EGroup 1 Intro Band──────────────────────────────────────────────────────────F M E░░░░░░░░░░░░░░░░░░░░░░░ASSOCIATED MANAGEMENT CONSULTANTS░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ATLANTA, GA 30350░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░╔═════════════════╗░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║░░░░░░░░░░░░░░░░░║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║░░I N V O I C E░░║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║░░░░░░░░░░░░░░░░░║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░╚═════════════════╝░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M EINVOICE DATE:░░XXXXXXXXXXXXXXXXXXXXXXXX░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░┌─────────────────────────────────────────────────┐░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░│░CUSTOMER:░░XXXXXXXXXXXXXXXXXXXXXXXXX░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░│░░░░░░░░░░░░XXXXXXXXXXXXXXXXXXXXXXXXX░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░│░░░░░░░░░░░░XXXXXXXXXXXXXXXXXXXXXXXXX░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░│░░░░░░░░░░░░XXXXXXXXXXXXXXXXXXXXXXXXX, XX XXXXX░│░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░└─────────────────────────────────────────────────┘░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░┌──────────────────────────────────────────────────────────────────┐░░░░░░░░F M E░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│░░░░░░░░F M E░░░░│░JOB:░XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX░░░░░░░░░░│░░░░░░░░F M E░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│░░░░░░░░F M E░░░░│░STARTING DATE:░MM/DD/YY░░░░COMPLETION DATE:░MM/DD/YY░░░DAYS:░999░│░░░░░░░░F M E░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│░░░░░░░░F M E░░░░└──────────────────────────────────────────────────────────────────┘░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░ACTIVITY SUMMARY:░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░HOURS░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M EGroup 2 Intro Band──────────────────────────────────────────────────────────F M EDetail Band──────────────────────────────────────────────────────────F M EGroup 2 Summary Band──────────────────────────────────────────────────────────F M E░░░░░░░░░░░░░░░░XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX░░░░░999.99░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M EGroup 1 Summary Band──────────────────────────────────────────────────────────F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░=========░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░TOTAL ALL ACTIVITIES░░░░░99,999.99░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░╔═════════════════════════════════════════════════════════════════════╗░░░░░F M E░░░░║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║░░░░░F M E░░░░║░░░░░░░░░░░░░░░░░░░TOTAL AMOUNT DUE:░░999,999.99░░░░░░░░░░░░░░░░░░░░░║░░░░░F M E░░░░║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║░░░░░F M E░░░░╚═════════════════════════════════════════════════════════════════════╝░░░░░F M EPage Footer Band──────────────────────────────────────────────────────────F M EReport Summary Band──────────────────────────────────────────────────────────FA!A! M PAAEPage 22 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E┌──────────────────────────────┐F P E│ REPORT DESIGN SCREEN - MENUS │F P E└──────────────────────────────┘F P MELayout Fields Bands Words Go To Print Exit 3:16:06 pmF M E╔════════════════════════════════════════╗···∙·· ·5····∙ ···6··· ∙····7· ··∙···]F M E║ Quick layouts ║──────────────────────────────────────F M E║────────────────────────────────────────║──────────────────────────────────────F M E║ Box ║──────────────────────────────────────F M E║ Line ║NT CONSULTANTS░░░░░░░░░░░░░░░░░░░░░░░░F M E║────────────────────────────────────────║E COURT░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E║ Use different database file or view ║05░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E║ Edit description of report ║ 30350░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E║ Save this report ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E╚════════════════════════════════════════╝══════╗░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║░░░░░░░░░░░░░░░░░║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║░░I N V O I C E░░║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║░░░░░░░░░░░░░░░░░║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░╚═════════════════╝░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M EINVOICE DATE:░░XXXXXXXXXXXXXXXXXXXXXXXX░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░┌─────────────────────────────────────────────────┐░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░│░CUSTOMER:░░XXXXXXXXXXXXXXXXXXXXXXXXX░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░│░░░░░░░░░░░░XXXXXXXXXXXXXXXXXXXXXXXXX░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░F M EReport ║D:\...bt4\INVOICE ║Band 1/9 ║View:INVOICE ║ CapsF M EPosition selection bar: Select: ─┘ Leave menu: EscF M ELayout Fields Bands Words Go To Print Exit 3:16:30 pmF M E[····∙·· ╔════════════════════════╗∙···· ····∙·· ·5····∙ ···6··· ∙····7· ··∙···]F M EReport ║ Add field ║─────────────────────────────────────────────F M EPage ║ Remove field ║─────────────────────────────────────────────F M EGroup 1 ║ Modify field ║─────────────────────────────────────────────F M E░░░░░░░░░║ Change hidden field ║ANAGEMENT CONSULTANTS░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░╚════════════════════════╝ELDSTONE COURT░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░SUITE 2205░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ATLANTA, GA 30350░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░╔═════════════════╗░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║░░░░░░░░░░░░░░░░░║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║░░I N V O I C E░░║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║░░░░░░░░░░░░░░░░░║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░╚═════════════════╝░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M EINVOICE DATE:░░XXXXXXXXXXXXXXXXXXXXXXXX░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░┌─────────────────────────────────────────────────┐░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░│░CUSTOMER:░░XXXXXXXXXXXXXXXXXXXXXXXXX░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░│░░░░░░░░░░░░XXXXXXXXXXXXXXXXXXXXXXXXX░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░F M EReport ║D:\...bt4\INVOICE ║Band 1/9 ║View:INVOICE ║ CapsF M EPosition selection bar: Select: ─┘ Leave menu: EscFA'A' M PAAE(c) Interco International Page 23 PEAAF P E┌──────────────────────────────┐F P E│ REPORT DESIGN SCREEN - MENUS │F P E└──────────────────────────────┘F P MELayout Fields Bands Words Go To Print Exit 3:10:31 pmF M E[····∙·· ╔════════════════════════╗∙···· ····∙·· ·5····∙ ···6··· ∙····7· ··∙···]F M E░░░░░░░░░║ Add field ║═════════════╝░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░║ Remove field ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M EINVOICE D║ Modify field ║XXXX░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░║ ╔═════════════════════════════════════════════════════════════╗░░░░F M E░░░░┌────╚═══║ Name {COMPDAYS} ║░░░░F M E░░░░│░░░░░░░░║ Description {} ║░░░░F M E░░░░│░CUSTOME║ Expression {compdate-startdate} ║░░░░F M E░░░░│░░░░░░░░║─────────────────────────────────────────────────────────────║░░░░F M E░░░░│░░░░░░░░║ Template {999} ║░░░░F M E░░░░│░░░░░░░░║ Picture functions {} ║░░░░F M E░░░░└────────║ Suppress repeated values NO ║░░░░F M E░░░░░░░░░░░░░║ Hidden NO ║░░░░F M E░░░░┌────────╚═════════════════════════════════════════════════════════════╝░░░░F M E░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│░░░░░░░░F M E░░░░│░JOB:░XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX░░░░░░░░░░│░░░░░░░░F M E░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│░░░░░░░░F M E░░░░│░STARTING DATE:░MM/DD/YY░░░░COMPLETION DATE:░MM/DD/YY░░░DAYS:░999░│░░░░░░░░F M E░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│░░░░░░░░F M E░░░░└──────────────────────────────────────────────────────────────────┘░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M EReport ║D:\...bt4\INVOICE ║Line:25 Col:67 ║View:INVOICE ║ CapsF M EPosition selection bar: Select: ─┘ Leave menu: EscF M ELayout Fields Bands Words Go To Print Exit 3:11:18 pmF M E[····∙·· ╔════════════════════════╗∙···· ····∙·· ·5····∙ ···6··· ∙····7· ··∙···]F M E░░░░░░░░░║ Add field ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░┌────║ Remove field ║────────────────────────────────────┐░░░░░░░░F M E░░░░│░░░░║ Modify field ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│░░░░░░░░F M E░░░░│░JOB║ ╔═════════════════════════════════════════════════════════════╗░░░░F M E░░░░│░░░░╚═══║ Name {JOBHOURS} ║░░░░F M E░░░░│░STARTIN║ Description {} ║░░░░F M E░░░░│░░░░░░░░║ Operation SUM ║░░░░F M E░░░░└────────║ ╔══════════╗marize on {HOURS} ║░░░░F M E░░░░░░░░░░░░░║ ║ AVERAGE ║ {JOBDESC} ║░░░░F M E░░░░░░ACTIVIT║───║ COUNT ║──────────────────────────────────────────────║░░░░F M E░░░░░░░░░░░░░║ ║ MAX ║ {99,999.99} ║░░░░F M E░░░░░░░░░░░░░║ ║ MIN ║tions {} ║░░░░F M EGroup 2 Int║ ║ SUM ║eated values NO ║────F M EDetail ║ ║ STD ║ NO ║────F M EGroup 2 Sum╚═══║ VAR ║══════════════════════════════════════════════╝────F M E░░░░░░░░░░░░░░░░X╚══════════╝XXXXXXXXXXXXXXXXXXXXXX░░░░░999.99░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M EGroup 1 Summary Band──────────────────────────────────────────────────────────F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░=========░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░TOTAL ALL ACTIVITIES░░░░░99,999.99░░░░░░░░░░░░░░░░░░F M EReport ║D:\...bt4\INVOICE ║Opt 5/7 ║View:INVOICE ║ CapsF M EPosition selection bar: Select: ─┘ Leave menu: EscFA'A' M PAAEPage 24 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E┌──────────────────────────────┐F P E│ REPORT DESIGN SCREEN - MENUS │F P E└──────────────────────────────┘F P MELayout Fields Bands Words Go To Print Exit 3:16:40 pmF M E[····∙·· ·1····∙ ·╔═══════════════════════════════════════════╗· ∙····7· ··∙···]F M EReport Intro ║ Add a group band ║─────────────────F M EPage Header ║ Remove group ║─────────────────F M EGroup 1 Intro ║ Modify group ║─────────────────F M E░░░░░░░░░░░░░░░░░░║ Group intro on each page NO ║░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░║───────────────────────────────────────────║░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░║ Open all bands ║░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░║ Begin band on new page NO ║░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░║ Word wrap band NO ║░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░║ Text pitch for band DEFAULT ║░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░║ Quality print for band DEFAULT ║░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░║ Spacing of lines for band DEFAULT ║░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░║───────────────────────────────────────────║░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░║ Page heading in report intro NO ║░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░╚═══════════════════════════════════════════╝░░░░░░░░░░░░░░░░░F M EINVOICE DATE:░░XXXXXXXXXXXXXXXXXXXXXXXX░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░┌─────────────────────────────────────────────────┐░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░│░CUSTOMER:░░XXXXXXXXXXXXXXXXXXXXXXXXX░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░│░░░░░░░░░░░░XXXXXXXXXXXXXXXXXXXXXXXXX░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░F M EReport ║D:\...bt4\INVOICE ║Band 1/9 ║View:INVOICE ║ CapsF M EPosition selection bar: Select: ─┘ Leave menu: EscF M ELayout Fields Bands Words Go To Print Exit 3:16:50 pmF M E[····∙·· ·1····∙ ···2··· ∙╔════════════════════════════════╗6··· ∙····7· ··∙···]F M EReport Intro Band────║ Style ║────────────────────F M EPage Header Band────║ Display ║────────────────────F M EGroup 1 Intro Band────║ Position ║────────────────────F M E░░░░░░░░░░░░░░░░░░░░░░░ASS║ Modify ruler ║░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░║ Hide ruler NO ║░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░║ Enable automatic indent YES ║░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░║────────────────────────────────║░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░║ Add line ║░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░║ Remove line ║░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░║ Insert page break ║░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░║ Write/read text file ║░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░╚════════════════════════════════╝░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░╚═════════════════╝░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M EINVOICE DATE:░░XXXXXXXXXXXXXXXXXXXXXXXX░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░┌─────────────────────────────────────────────────┐░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░│░CUSTOMER:░░XXXXXXXXXXXXXXXXXXXXXXXXX░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░│░░░░░░░░░░░░XXXXXXXXXXXXXXXXXXXXXXXXX░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░F M EReport ║D:\...bt4\INVOICE ║Band 1/9 ║View:INVOICE ║ CapsF M EPosition selection bar: Select: ─┘ Leave menu: EscFA'A' M PAAE(c) Interco International Page 25 PEAAF P E┌──────────────────────────────┐F P E│ REPORT DESIGN SCREEN - MENUS │F P E└──────────────────────────────┘F P MELayout Fields Bands Words Go To Print Exit 3:17:04 pmF M E[····∙·· ·1····∙ ···2··· ∙····3· ·╔═════════════════════════════════════════╗··]F M EReport Intro Band────────────║ Go to line number {0} ║───F M EPage Header Band────────────║─────────────────────────────────────────║───F M EGroup 1 Intro Band────────────║ Forward search {} ║───F M E░░░░░░░░░░░░░░░░░░░░░░░ASSOCIATED ║ Backward search {} ║░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░1170 ║ Replace {} ║░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ Match capitalization NO ║░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ATL╚═════════════════════════════════════════╝░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░╔═════════════════╗░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║░░░░░░░░░░░░░░░░░║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║░░I N V O I C E░░║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║░░░░░░░░░░░░░░░░░║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░╚═════════════════╝░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M EINVOICE DATE:░░XXXXXXXXXXXXXXXXXXXXXXXX░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░┌─────────────────────────────────────────────────┐░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░│░CUSTOMER:░░XXXXXXXXXXXXXXXXXXXXXXXXX░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░│░░░░░░░░░░░░XXXXXXXXXXXXXXXXXXXXXXXXX░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░F M EReport ║D:\...bt4\INVOICE ║Band 1/9 ║View:INVOICE ║ CapsF M EPosition selection bar: Select: ─┘ Leave menu: EscFA*A* A(A( M PAAEPage 26 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E┌──────────────────────────────┐F P E│ REPORT DESIGN SCREEN - MENUS │F P E└──────────────────────────────┘F P MELayout Fields Bands Words Go To Print Exit 3:17:25 pmF M E[····∙·· ·1····∙ ···2··· ∙····3· ··∙···· ·╔═══════════════════════════════════╗]F M EReport Intro Band────────────────────║ Begin printing ║─F M EPage Header Band────────────────────║ Eject page now ║─F M EGroup 1 Intro Band────────────────────║ View report on screen ║─F M E░░░░░░░░░░░░░░░░░░░░░░░ASSOCIATED MANAGEME║───────────────────────────────────║░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░1170 WELDSTON║ Use print form {INVOICE.prf} ║░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░SUITE 22║ Save settings to print form ║░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ATLANTA, GA║───────────────────────────────────║░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ Destination ║░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░╔═══════════║ Control of printer ║░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║░░░░░░░░░░░║ Output options ║░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║░░I N V O I║ Page dimensions ║░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║░░░░░░░░░░░╚═══════════════════════════════════╝░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░╚═════════════════╝░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M EINVOICE DATE:░░XXXXXXXXXXXXXXXXXXXXXXXX░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░┌─────────────────────────────────────────────────┐░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░│░CUSTOMER:░░XXXXXXXXXXXXXXXXXXXXXXXXX░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░│░░░░░░░░░░░░XXXXXXXXXXXXXXXXXXXXXXXXX░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░F M EReport ║D:\...bt4\INVOICE ║Band 1/9 ║View:INVOICE ║ CapsF M EPosition selection bar: Select: ─┘ Leave menu: EscF M ELayout Fields Bands Words Go To Print Exit 3:17:57 pmF M E[····∙·· ·1····∙ ···2··· ∙····3· ··∙···· ·╔═══════════════════════════════════╗]F M EReport Intro Band────────────────────║ Begin printing ║─F M EPage Header Band────────────────────║ Eject page now ║─F M EGroup 1 Intro Band────────────────────║ View report on screen ║─F M E╔══════════════════════════════════════════════╗──────────────────────────────║░F M E║ Text pitch DEFAULT ║e print form {INVOICE.prf} ║░F M E║ Quality print DEFAULT ║ve settings to print form ║░F M E║──────────────────────────────────────────────║──────────────────────────────║░F M E║ New page AFTER ║stination ║░F M E║ Wait between pages NO ║ntrol of printer ║░F M E║ Advance page using FORM FEED ║tput options ║░F M E║──────────────────────────────────────────────║ge dimensions ║░F M E║ Starting control codes {} ║══════════════════════════════╝░F M E║ Ending control codes {} ║╝░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E╚══════════════════════════════════════════════╝░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M EINVOICE DATE:░░XXXXXXXXXXXXXXXXXXXXXXXX░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░┌─────────────────────────────────────────────────┐░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░│░CUSTOMER:░░XXXXXXXXXXXXXXXXXXXXXXXXX░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░│░░░░░░░░░░░░XXXXXXXXXXXXXXXXXXXXXXXXX░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░F M EReport ║D:\...bt4\INVOICE ║Band 1/9 ║View:INVOICE ║ CapsF M EPosition selection bar: Select: ─┘ Leave menu: EscFA'A' M PAAE(c) Interco International Page 27 PEAAF P MEASSOCIATED MANAGEMENT CONSULTANTSF M E1170 WELDSTONE COURTF M ESUITE 2205F M EATLANTA, GA 30350F M E╔══════════════════╗F M E║ ║F M E║ I N V O I C E ║F M E║ ║F M E╚══════════════════╝F M EINVOICE DATE: February 15, 1989F M E┌──────────────────────────────────────────────────┐F M E│ │F M E│ CUSTOMER: Brighton Associates │F M E│ 123 South Surrey │F M E│ Malibu Beach, CA 23456 │F M E│ │F M E└──────────────────────────────────────────────────┘F M E┌───────────────────────────────────────────────────────────────────┐F M E│ │F M E│ JOB: Sales Force Mail File │F M E│ │F M E│ STARTING DATE: 01/01/89 COMPLETION DATE: 02/15/89 DAYS: 45 │F M E│ │F M E└───────────────────────────────────────────────────────────────────┘F M EACTIVITY SUMMARY:F M EHOURSF M EA. Define System Concept 144.00F M EB. System Design 38.00F M EC. Create System with dBase IV 70.00F M ED. Install and Work with Users 64.00F M EE. Make Modifications to System 36.00F M E=========F M ETOTAL ALL ACTIVITIES 352.00F M E╔══════════════════════════════════════════════════════════════════════╗F M E║ ║F M E║ TOTAL AMOUNT DUE: 34,000.00 ║F M E║ ║F M E╚══════════════════════════════════════════════════════════════════════╝F M ETHANKS FOR YOUR SUPPORTFAA M PAAEPage 28 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E┌────────────────────────────────┐F P E│ REPORT DESIGN SCREEN - JOBSTAT │F P E└────────────────────────────────┘F P MEPage Header Band──────────────────────────────────────────────────────────F M EReport Intro Band──────────────────────────────────────────────────────────F M EGroup 1 Intro Band──────────────────────────────────────────────────────────F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░JOB STATUS REPORT░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░┌──────────────────────────────────────────────────────────────┐░░░░░░░░░░░░░░F M E░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│░░░░░░░░░░░░░░F M E░░│░JOB:░░░░░░XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX░│░░░░░░░░░░░░░░F M E░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│░░░░░░░░░░░░░░F M E░░│░CUSTOMER:░XXXXXXXXXXXXXXXXXXXXXXXXX░░░░░░░░░░░░░░░░░░░░░░░░░░│░░░░░░░░░░░░░░F M E░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│░░░░░░░░░░░░░░F M E░░└──────────────────────────────────────────────────────────────┘░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░STAFF MEMBER░░░░░░░░░░░░░░░░░░░DATE░░░░░░░░HOURS░░░░░░░░AMOUNT░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M EGroup 2 Intro Band──────────────────────────────────────────────────────────F M EDetail Band──────────────────────────────────────────────────────────F M E░░░░░░░░XXXXXXXXXXXXXXXXXXXXXXXXXX░░MM/DD/YY░░░░░9,999.99░░░9999,999.99░░░░░░░░░F M EGroup 2 Summary Band──────────────────────────────────────────────────────────F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M EGroup 1 Summary Band──────────────────────────────────────────────────────────F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░┌────────────────────────────────────────────────────────────────────┐░░░░░░░F M E░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│░░░░░░░F M E░░░│░JOB:░XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX░░░░░░░░░░░░│░░░░░░░F M E░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│░░░░░░░F M E░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░TO DATE:░░░░░9,999.99░░░9999,999.99░│░░░░░░░F M E░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│░░░░░░░F M E░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░BID PRICE:░░░░░░░░░░░░░░9999,999.99░│░░░░░░░F M E░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░-----------░│░░░░░░░F M E░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│░░░░░░░F M E░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░VARIANCE:░░░░░░░░░░░░░░░9999,999.99░│░░░░░░░F M E░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│░░░░░░░F M E░░░└────────────────────────────────────────────────────────────────────┘░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M EReport Summary Band──────────────────────────────────────────────────────────F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░╔═════════════════════════════════════════╗░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║░TOTAL TO DATE:░░░9,999.99░░░9999,999.99░║░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║═════════════════════════════════════════║░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║░TIME SLIPS:░999░░░░░░░░░░░░░░░░░░░░░░░░░║░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║░AVG TO DATE:░░░░░9,999.99░░░9999,999.99░║░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░╚═════════════════════════════════════════╝░░░░░░░F M EPage Footer Band──────────────────────────────────────────────────────────F M EReport Date: 10/19/88F M ETime: 15:33:20FA*A* M PAAE(c) Interco International Page 29 PEAAF P MEJOB STATUS REPORTF M E▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒F M E┌───────────────────────────────────────────────────────────────┐F M E│ │F M E│ JOB: Class Scheduling Program │F M E│ │F M E│ CUSTOMER: General Services Admin │F M E│ │F M E└───────────────────────────────────────────────────────────────┘F M ESTAFF MEMBER DATE HOURS AMOUNTF M EMarie, Lisa 01/20/89 22.00 550.00F M E01/20/89 22.00 550.00F M E01/27/89 10.00 250.00F M EBruce, Charles 01/06/89 12.00 660.00F M E01/13/89 6.00 330.00F M E01/20/89 12.00 660.00F M E01/27/89 6.00 330.00F M E┌─────────────────────────────────────────────────────────────────────┐F M E│ │F M E│ JOB: Class Scheduling Program │F M E│ │F M E│ TO DATE: 100.00 3,580.00 │F M E│ │F M E│ BID PRICE: 9,500.00 │F M E│ ----------- │F M E│ │F M E│ VARIANCE: 5,920.00 │F M E│ │F M E└─────────────────────────────────────────────────────────────────────┘FA)A) M PAAEPage 30 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P MEPage No. 1F M EReport Date: 10/19/88F M EEMPLOYEE PAY RATE REPORTF M E▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒F M E┌──────────────────────────┐F M E│ Department: CORP │F M E└──────────────────────────┘F M EID NAME RATEF M ECO200 Bonnie Connors 60.00F M ELA100 Jean Lacroux 50.00F M EMI100 Sally Middleton 50.00F M EZO100 Leigh Zoellner 50.00F M E┌─────────────────────────────────┐F M E│ Department Average 52.50 │F M E└─────────────────────────────────┘F M E┌──────────────────────────┐F M E│ Department: MIS │F M E└──────────────────────────┘F M EID NAME RATEF M ETR100 Charles Bruce 55.00F M ERI100 Nell Ridley 45.00F M ETR200 George Troutman 50.00F M E┌─────────────────────────────────┐F M E│ Department Average 50.00 │F M E└─────────────────────────────────┘F M E┌──────────────────────────┐F M E│ Department: PROG │F M E└──────────────────────────┘F M EID NAME RATEF M EBA100 Kevin Barry 60.00F M EBO100 Jeff Bonnacker 40.00F M EBR200 Stuart Brooks 50.00F M EBR300 Robert Bruce 65.00F M ECO100 Kael Cognac 35.00F M EJO100 Allison Jonah 40.00F M EKA100 Holly Kathleenovitch 50.00F M ELA200 Blaise Lacroux 35.00F M ERA100 Joseph Randall 50.00F M E┌─────────────────────────────────┐F M E│ Department Average 47.22 │F M E└─────────────────────────────────┘FA!A! M PAAE(c) Interco International Page 31 PEAAF P E┌─────────────────┐F P E│ DATA VALIDATION │F P E└─────────────────┘F P EData Validation is the technique where the computer verifiesF P Ethe data that is entered into your files. There are four basicF P Etechniques:F P EValidate the form of the information.F P EValidate against a range of acceptable values.F P EValidate against a list of acceptable values.F P EValidate against values in other data files.F P EIn the TIME.DBF we want to use all four techniques:F P EAll Employee and Job Id's must follow a pattern ofF P Eletters then numbers and all letters must be in upperF P Ecase.F P EDates must fall in 1989 and Hours cannot exceed 50F P Ehours.F P EFunction Codes must be one of 5 choices.F P EAll Employee and Job Id's must be found in theirF P Ecorresponding data files.FA*A* A(A( P EPage 32 (c) Interco InternationalPEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒F P EIMPORTANT NOTE: In order to use the data file look upF P Etechnique a relationship between theF P Efiles must be created. UnfortunatelyF P Ethis CANNOT be done in the Query PanelF P Eof the Control Center. Please use theF P Efollowing method.F P E1. Exit the Control Center to the Dot Prompt.F P E2. Enter the following for the TIME example:F P E.USE TIME IN AF P E.USE EMP ORDER EMPID IN BF P E.USE JOB ORDER JOBID IN CF P E.CREATE VIEW TIMEEDIT FROM ENVIRONMENTF P E3. Press <F2> (ASSIST) to return to ControlF P ECenter.F P E4. Cursor to the Query Panel and press <ALT> <C>F P Ethen <A> to add TIMEEDIT to the Catalog.F P ETIMEEDIT.VUE will now be available for use in the FormF P EPanel.F P E▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒FA*A* A(A( P E(c) Interco International Page 33PEAAF P MELayout Fields Words Go To Exit 3:37:57 pmF M E╔════════════════════════════════════════╗···∙·· ·5····∙ ···6··· ∙····7· ··∙···]F M E║ Quick layout ║░░░░░░░░░░░░░░░░░░░╔═══════════════╗░░F M E║────────────────────────────────────────║░░░░░░░░░░░░░░░░░░░║ JOBCOST ║░░F M E║ Box ║░░░░░░░░░░░░░░░░░░░║═══════════════║░░F M E║ Line ║ATION FORM░░░░░░░░░║ CUSTOMER.DBF ║░░F M E║────────────────────────────────────────║░░░░░░░░░░░░░░░░░░░║ EMP.DBF ║░░F M E║ >Use different database file or view ║───────────────────║ EMPPROG.QBE ║░░F M E║ Edit description of form ║░░░░░░░░░░░░░░░░░░░║ EMPRATE.DBF ║░░F M E║ Save this form ║ID░░░░░Hours░░Funct║ EMPRATE.QBE ║░░F M E╚════════════════════════════════════════╝░░░░░░░░░░░░░░░░░░░║ FUNCODE.DBF ║░░F M E░░░░░░░░░░░░│░░░░MM/DD/YY░░░░░AA999░░░░AAA99░░░░999.99░░░XXXX║ INVOICE.QBE ║░░F M E░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ JOB.DBF ║░░F M E░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ JOBSTAT.QBE ║░░F M E░░░░░░░░░░░░└────────────────────────────────────────────────║ TIME.DBF ║░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║>TIMEEDIT.VUE ║░░F M E░░░░░░░░┌─────────────────────────────────────────────┐░░░░░░╚═══════════════╝░░F M E░░░░░░░░│View for Time Slip Editing │░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░│ │░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░└─────────────────────────────────────────────┘░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M EForm ║D:\...classes\bt4\TIME ║Opt 11/11 ║View:TIMEEDIT ║ CapsF M EPosition selection bar: Select: ─┘ Leave picklist: EscF M ELayout Fields Words Go To Exit 3:35:52 pmF M E[····∙·· ·1····∙ ···2··· ∙····3· ··∙···· ····∙·· ·5····∙ ···6··· ∙····7· ··∙···]F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░TIME SLIP INFORMATION FORM░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░┌───────────────────────────────────────────────────────┐░░░░░░░░░░░F M E░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│░░░░░░░░░░░F M E░░░░░░░░░░░░│░░░░░░░Date░░░░░Emp ID░░░Job ID░░░░░Hours░░Function░░░░│░░░░░░░░░░░F M E░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│░░░░░░░░░░░F M E░░░░░░░░░░░░│░░░░MM/DD/YY░░░░░AA999░░░░AAA99░░░░999.99░░░XXXXXX░░░░░│░░░░░░░░░░░F M E░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│░░░░░░░░░░░F M E░░░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│░░░░░░░░░░░F M E░░░░░░░░░░░░└───────────────────────────────────────────────────────┘░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M EForm ║D:\...classes\bt4\TIME ║Row:0 Col:0 ║View:TIMEEDIT ║ CapsInsF M EAdd field:F5 Select:F6 Move:F7 Copy:F8 Size:Shift-F7FA'A' M PAAEPage 34 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P MELayout Fields Words Go To Exit 3:36:33 pmF M E[····∙·· ╔═══════════════════════════╗·· ····∙·· ·5····∙ ···6··· ∙····7· ··∙···]F M E░░░░░░░░░║ Add field ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░║ Remove field ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░║ Modify field ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░║───╔═════════════════════════════════════════════════╗░░░░░░░░░░░░░░░░F M E░░░░░░░░░║ ║ Field name: EMPID ║░░░░░░░░░░░░░░░░F M E░░░░░░░░░╚═══║ Type: Character ║────┐░░░░░░░░░░░F M E░░░░░░░░░░░░│║ Length: 5 ║░░░░│░░░░░░░░░░░F M E░░░░░░░░░░░░│║ Decimals: 0 ║░░░░│░░░░░░░░░░░F M E░░░░░░░░░░░░│║─────────────────────────────────────────────────║░░░░│░░░░░░░░░░░F M E░░░░░░░░░░░░│║ Template AA999 ║░░░░│░░░░░░░░░░░F M E░░╔ Character Template Symbols ══════════════════════════════════════════════╗░░F M E░░║ ║░░F M E░░║ 9 Accept digits and signs Y Y or N ║░░F M E░░║ # Accept digits, spaces, L T, F, Y, or N ║░░F M E░░║ signs, and periods X Any character ║░░F M E░░║ A Accept alpha characters ! Convert to uppercase ║░░F M E░░║ N Accept alpha, digits, and other Insert into display. ║░░F M E░░║ underscore Store with input data unless ║░░F M E░░║ @R function is used. ║░░F M E░░╚══════════════════════════════════════════════════════════════════════════╝░░F M EForm ║D:\...classes\bt4\TIME ║Row:9 Col:30 ║View:TIMEEDIT ║ CapsF M EZoom: F9 Accept: ─┘ Cancel: EscF M ELayout Fields Words Go To Exit 3:36:48 pmF M E[····∙·· ╔═══════════════════════════╗·· ····∙·· ·5····∙ ···6··· ∙····7· ··∙···]F M E░░░░░░░░░║ Add field ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░║ Remove field ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░║ Modify field ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░║───╔═════════════════════════════════════════════════╗░░░░░░░░░░░░░░░░F M E░░░░░░░░░║ ║ Field name: ╔══════════════════════════════════════════╗░F M E░░░░░░░░░╚═══║ Type: ║ Alphabetic characters only A OFF ║░F M E░░░░░░░░░░░░│║ Length: ║ Upper-case conversion ! ON ║░F M E░░░░░░░░░░░░│║ Decimals: ║ Literals not part of data R OFF ║░F M E░░░░░░░░░░░░│║─────────────────────║ Scroll within display width S OFF ║░F M E░░░░░░░░░░░░│║ Template ║ Multiple choice M OFF ║░F M E░░░░░░░░░░░░│║ Picture functions ║──────────────────────────────────────────║░F M E░░░░░░░░░░░░│║ Edit options ║ Trim T OFF ║░F M E░░░░░░░░░░░░└║ Display as ║ Right align J OFF ║░F M E░░░░░░░░░░░░░║ Border lines ║ Center align I OFF ║░F M E░░░░░░░░░░░░░╚═════════════════════║ Horizontal stretch H OFF ║░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ Vertical stretch V OFF ║░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ Wrap semicolons ; OFF ║░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░╚══════════════════════════════════════════╝░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M EForm ║D:\...classes\bt4\TIME ║Row:9 Col:30 ║View:TIMEEDIT ║ CapsF M EPosition selection bar: Select: ─┘ Accept: Ctrl-End Cancel: EscFA'A' M PAAE(c) Interco International Page 35 PEAAF P MELayout Fields Words Go To Exit 3:37:13 pmF M E[····∙·· ╔═══════════════════════════╗·· ····∙·· ·5····∙ ···6··· ∙····7· ··∙···]F M E░░░░░░░░░║ Add field ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░║ Remove field ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░║ Modify field ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░║───╔═════════════════════════════════════════════════╗░░░░░░░░░░░░░░░░F M E░░░░░░░░░║ ║ Field name: EMPID ║░░░░░░░░░░░░░░░░F M E░░░░░░╔══════════════════════════════════════════════════════════════════╗░░░░░░F M E░░░░░░║ Editing allowed YES ║░░░░░░F M E░░░░░░║ Permit edit if {} ║░░░░░░F M E░░░░░░║ Message {Enter Employee Number} ║░░░░░░F M E░░░░░░║ Carry Forward NO ║░░░░░░F M E░░░░░░║ Default value {} ║░░░░░░F M E░░░░░░║ Smallest allowed value {} ║░░░░░░F M E░░░░░░║ Largest allowed value {} ║░░░░░░F M E░░░░░░║ Accept value when {seek(EMPID,"EMP")} ║░░░░░░F M E░░░░░░║ Unaccepted message {Employee Id is not in Employee File. } ║░░░░░░F M E░░░░░░╚══════════════════════════════════════════════════════════════════╝░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F M EForm ║D:\...classes\bt4\TIME ║Row:9 Col:30 ║View:TIMEEDIT ║ CapsF M EPosition selection bar: Select: ─┘ Accept: Ctrl-End Cancel: EscFA*A* A'A' M PAAEPage 36 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E┌─────────────────────────────────┐F P E│ PRINCIPLES OF GOOD PROGRAMMING │F P E└─────────────────────────────────┘F P E┌────────────────────────────────────────┐F P E│ SPEED vs COST vs MAINTENANCE DECISIONS │F P E└────────────────────────────────────────┘F P EThe Speed Issue -- How fast will the program run.F P EThe Cost Issue -- How much will the program costF P Eto develop and how much willF P Eit cost to run.F P EThe Maintenance Issue -- How much will it cost to makeF P Echanges to the existingF P Eprogram in the future.F P EIn the days before microcomputers there was a basic rule forF P Eprogramming systems on a computer:F P ETHE SYSTEM MUST WORK PROPERLY AND BE FASTF P EThe reasoning behind this philosophy was the high cost ofF P Ecomputer time often running at hundreds, even thousands ofF P Edollars an hour. Therefore, if the time could be cut in half thenF P Ecosts would be reduced substantially. This objective led toF P Einnovative techniques in both equipment design and programming.F P EThere was an undesirable side effect however. The individuals whoF P Eused the creative programming techniques were the only people whoF P Eunderstood how to make changes to the programs. Thus managementF P Ehad a dilemma when changes were needed. Work with the originalF P Eprogrammer on his terms or redesign the entire system. The costF P Eunder either scenario could be substantial.F P EOver the years a management mind set has been developed:F P Eprogrammers are to be respected and feared, systems are timeF P Econsuming and costly, and simple changes to systems often cost asF P Emuch as the original.F P EThis mind set was continued in the early days of theF P Emicrocomputer. However several of the basic cost elements haveF P Ebeen reduced in significance: the expense of the computerF P Eequipment and the speed at which the programs run. With timeF P Esharing costs all but gone and the speed of processing at a highF P Elevel the pressure for speed through creative programming isF P Egone. The emphasis has shifted to obtaining systems that can beF P Emodified at reasonable costs thus giving the basic rule forF P Eprogramming today:FA*A* A A P E(c) Interco International Page 37PEAAF P ETHE SYSTEM MUST WORK PROPERLY AND ALLOW CHANGES BY SOMEONE ELSEF P EdBase II required a professional programmer to createF P Esystems that included sophisticated tasks. Although dBase III andF P EIII Plus provide enhanced tools they still require theF P Eexperienced person with full command of elemental dBaseF P Einstructions. Modifications to existing systems require the sameF P Eskills.F P EdBase IV provides a solution to this problem. The majorityF P Eof the programming instructions are written through theF P EApplications Generator, APGEN. APGEN prompts the programmer forF P Eitems of information that it needs to write a program thenF P Eproduces a program. It is very flexible with the ability toF P Eproduce menus, calculation routines and maintenance activitiesF P Ewithout requiring years of experience with dBase commands. ForF P Ethose programs that require special dBase commands APGEN allowsF P Ethe insertion of custom programs into its own generated code.F P EThe benefits of using APGEN are:F P E1. Programs written by APGEN are easily modified byF P Eusing APGEN. No longer do simple modificationsF P Erequire a complete rewrite of the originalF P Eprogram.F P E2. It requires less time to learn APGEN and itsF P Ecapabilities than to learn programming byF P Etraditional methods. More people can produceF P Eworking systems in shorter time frames.F P E3. APGEN written programs can be tested and debuggedF P Ein far less time than a hand coded program thatF P Eattempts to accomplish the same results.F P E4. APGEN comes at no extra charge in each copy aF P EdBase IV.F P EIn summary, the speed and cost of running a program are veryF P Efavorable with current equipment and therefore not major issuesF P Ein analyzing today's systems. The cost of development and ofF P Emaintenance can remain high, if management does not requireF P Eprograms to be written using application generators. dBase IV andF P EAPGEN provide the tools to build and operate programming systemsF P Efor now and for the foreseeable future.FA*A* A$A$ P EPage 38 (c) Interco InternationalPEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E┌─────────────────┐F P E│ The Golden Rule │F P E└─────────────────┘F P EA system is well designed if the following balance is beF P Emade:F P EThe Customer is satisfied by the systems' performanceF P Eand cost andF P EThe design effort is adequately compensated for theF P Eresources expended to build the system.F P E┌───────────────┐F P E│ Documentation │F P E└───────────────┘F P EDocumenting programming work is essential for futureF P Emodifications at reasonable costs. At best hand coded programsF P Eare difficult to change effectively. When programs are producedF P Eby the Applications Generator, APGEN, dBase IV can produceF P Eoutline documentation. This is done at generation time byF P Eselecting DOCUMENT.GEN from the Generate Menu. CLEAR is a thirdF P Eparty product (Clear Software, 1-800-338-1759) that produces flowF P Echarts for dBase programs including dBase IV. dANALYST 4F P E(Buzzwords International, 1-314-334-0794) produces crossF P Ereferences, block diagrams, file and index documentation forF P EdBase programs. A portion of the DOCUMENT.GEN results are shownF P Ehere:FA*A* P E(c) Interco International Page 39PEAAF P MEFrom DOCUMENT.GEN on JOBCOST.PRGF M EPage: 1 Date: 11-29-88F M EApplication Documentation for System: JOBMENU.PRGF M EApplication Author: Bruce TroutmanF M ECopyright Notice..: Interco International, Ltd.F M EdBASE Version.....: dBase IVF M EDisplay Application Sign-On Banner: NoF M EMain Menu to Open : MAINBAR.BARF M ESets for Application:F M E---------------------F M EBell ONF M ECarry OFFF M ECentry OFFF M EConfirm OFFF M EDelimiters OFFF M EDisplay Size 25 linesF M EDriveF M EEscape ONF M EPathF M ESafety ONF M EStarting Colors for Application:F M E--------------------------------F M EColor Settings:F M EText : W+/BF M EHeading : W/BF M EHighlight : B/WF M EBox : B/WF M EMessages : W+/NF M EInformation : B/WF M EFields : B/WF M EDatabase/View: TIMEF M E===============================================================================F M EMenu/Picklist definitions follow:F M E---------------------------------FA*A* A!A! M PAAEPage 40 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E┌─────────────────────────────────────────────────┐F P E│ DEVELOPMENT OF SYSTEMS WITH DEVELOPER'S EDITION │F P E└─────────────────────────────────────────────────┘F P EAdvanced tools are available for system development withF P EdBase IV. They are contained in the Developer's Edition whichF P Ecosts a few hundred dollars more than the basic edition. IncludedF P Eare the tools required to design, build and distribute systemsF P Ewithout paying additional licensing fees or royalties to Ashton-F P ETate.F P EThere are three benefits from using advanced tools:F P E1. THE COSTS OF SYSTEM DISTRIBUTION IS REDUCEDF P ESUBSTANTIALLY. If 50 installations of the systemF P Eare required, the choice is to give each one aF P Ecopy of dBase IV at a retail cost of approximatelyF P E$40,000 US or buy one Developer's Edition atF P E$1,295 US and distribute Runtime versions of theF P Esystem.F P E2. THE USERS WILL NOT BE ABLE TO MODIFY SYSTEMF P EPROGRAMS. The process of creating a runtime orF P Ecompiled program automatically encodes theF P Eoriginal source program thus ensuring that whatF P Ethe users are supposed to be using has not beenF P Etinkered with by some well-meaning dBase hacker.F P E3. THE SYSTEM PROGRAMS WILL EXECUTE FASTER. The basicF P Elimitation to speed for a system involved theF P Eamount of translation to be done before a commandF P Ecan be executed. The runtime/compiler option doesF P Etranslation prior to distribution. Therefore theF P Euser's machine will not waste time in theF P Etranslation.F P EThe substantial benefit of the Developer's Edition is theF P Ereduced cost of distributing systems to multiple users. TheF P Eadditional cost is insignificant against the cost of multipleF P Ecopies of dBase for the users.FA)A) P E(c) Interco International Page 41PEAAF P E┌───────────────────────────────┐F P E│ PROGRAMMING WINDOWS AND MENUS │F P E└───────────────────────────────┘F P EdBase IV provides the Applications Panel in the ControlF P ECenter. From this panel virtually any system can be designed.F P EMenus provide the user with a method of navigating through aF P Esystem in the manner chosen by the designer. Menus call otherF P Emenus as well as perform designated tasks such as reporting andF P Ecalculations. In the first course, "Designing Databases withF P EdBase IV", the use of the quick application features wereF P Ediscussed. It will not be reiterated here. Since dBase IVF P Egenerates the commands which cause Menus to happen, we willF P Ecreate a simple menu and study the dBase commands used. Then weF P Ewill study the complete JOBMENU application.F P ECUSTOMER MENUF P EThere are four functions desired for our sample CustomerF P EMenu:F P EADD CHANGE REPORT EXITF P EWhen ADD is selected records can be added. When CHANGE is chosenF P Erecords can be Edited and Browsed. For REPORT the Customer ReportF P Eshould be produced. Exit should return the user to the ControlF P ECenter.FA*A* A(A( P EPage 42 (c) Interco InternationalPEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P MECatalog Tools Exit 9:04:05 amF M EdBASE IV CONTROL CENTERF M ECATALOG: D:\DBSYS\CLASSES\BT4W\JOBCOST.CATF M EData Queries Forms Reports Labels ApplicationsF M E╔════════════╦════════════╦════════════╦════════════╦════════════╦════════════╗F M E║ <create> ║ <create> ║ <create> ║ <create> ║ <create> ║ <create> ║F M E║─────────╔══════════════════════════════════════════════════════════╗────────║F M E║ CUSTOME║ ║STEXAM ║F M E║ EMP ║ dBASE program Applications Generator ║STOMER ║F M E║ EMPRATE║ ║P ║F M E║ FUNCODE║ You may create a dBASE program, or an application with ║PRATE ║F M E║ JOB ║ the Applications Generator. Press ENTER to select or ║NCODE ║F M E║ TIME ║ ESC to cancel. ║B ║F M E║ ║ ║BMENU ║F M E║ ╚══════════════════════════════════════════════════════════╝ME ║F M E╚════════════╩════════════╩════════════╩════════════╩════════════╩════════════╝F M EFile: New fileF M EDescription: Press ENTER on <create> to create a new fileF M ESelect option and press ENTER, or press first letter of desired optionF M EDesign Application Generate Preset Exit 9:06:02 amF M E╔══════════════════════════════════════════════════════════════════════════════╗F M E║ Application Definition ║F M E║ ║F M E║ Application name: CUSTEXAM ║F M E║ Description: Customer Application Example ║F M E║ Main menu type: BAR ║F M E║ Main menu name: CUSTMENU ║F M E║ Database/view: CUSTOMER ║F M E║ Set INDEX to: ║F M E║ ORDER: CUSTNAME ║F M E║ ║F M E╚══════════════════════════════════════════════════════════════════════════════╝F M EApp ║ ║ ║ ║F M EAccept: Ctrl-End Cancel: EscFAA M PAAE(c) Interco International Page 43 PEAAF P MEDesign Application Generate Preset Exit 9:51:45 amF M E╔════════════════════════╗ ∙ ∙ + ∙ ∙ ∙ ∙ ∙ ∙ ∙F M E║ Horizontal bar menu ║F M E╔══════════════════════════════════════════════════════════════════════════════╗F M E║ ║F M E║ Name: CUSTMENU ║F M E║ Description: Class Example Menu ║F M E║ ║F M E║ Message line prompt: ║F M E║ CLASS EXAMPLE MENU ║F M E║ ║F M E╚══════════════════════════════════════════════════════════════════════════════╝F M E11 ║ ║F M E12 ∙ ║ See Application menu to use as sign-on banner. ║∙ ∙F M E13 ║ ║F M E14 ∙ ║ ║∙ ∙F M E15 ║ ║F M E16 ∙ ╚═══════════════════════════════════════════════════════════╝∙ ∙F M E17F M E18 ∙ ∙ ∙ ∙ ∙ ∙ ∙ + ∙ ∙ ∙ ∙ ∙ ∙ ∙F M E19F M E20∙∙∙+∙∙∙∙1∙∙∙∙+∙∙∙∙2∙∙∙∙+∙∙∙∙3∙∙∙∙+∙∙∙∙4∙∙∙∙+∙∙∙∙5∙∙∙∙+∙∙∙∙6∙∙∙∙+∙∙∙∙7∙∙∙∙+∙∙∙∙F M EApp ║D:\...bt4w\CUSTEXAM ║ ║File:CUSTOMER ║F M EAccept: Ctrl-End Cancel: EscF M EDesign Menu Item Generate Preset Exit 9:53:14 amF M E╔══════════════════════════════════════════════════════════════════════════════╗F M E║ ADD ║F M E╚══════════════════════════════════════════════════════════════════════════════╝F M E3F M E4 ∙ ∙ ∙ ∙ ∙ ∙ ∙ + ∙ ∙ ∙ ∙ ∙ ∙ ∙F M E5 ╔═══════════════════════════════════════════════════════════╗F M E6 ∙ ║ ║∙ ∙F M E7 ║ ║F M E8 ∙ ║ This is an APPLICATION OBJECT. ║∙ ∙F M E9 ║ ║F M E10 ∙ ║ Type information here or greetings to your users. ║∙ ∙F M E11 ║ ║F M E12 ∙ ║ See Application menu to use as sign-on banner. ║∙ ∙F M E13 ║ ║F M E14 ∙ ║ ║∙ ∙F M E15 ║ ║F M E16 ∙ ╚═══════════════════════════════════════════════════════════╝∙ ∙F M E17F M E18 ∙ ∙ ∙ ∙ ∙ ∙ ∙ + ∙ ∙ ∙ ∙ ∙ ∙ ∙F M E19F M E20∙∙∙+∙∙∙∙1∙∙∙∙+∙∙∙∙2∙∙∙∙+∙∙∙∙3∙∙∙∙+∙∙∙∙4∙∙∙∙+∙∙∙∙5∙∙∙∙+∙∙∙∙6∙∙∙∙+∙∙∙∙7∙∙∙∙+∙∙∙∙F M EApp ║D:\...bt4w\CUST1 ║Row: 1 Col:10 ║File:CUSTOMER ║F M EPrev/Next object: F3/F4 Move/Copy: F7/F8 Size: Shift-F7 Menus: F10FAA M PAAEPage 44 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P MEDesign Menu Item Generate Preset Exit 9:07:34 amF M E0 ∙ ∙ ∙ ∙ ∙ ∙ ∙ + ∙ ∙ ∙ ∙ ∙ ∙ ∙F M E╔══════════════════════════════════════════════════════════════════════════════╗F M E║ ADD CHANGE REPORT EXIT ║F M E╚══════════════════════════════════════════════════════════════════════════════╝F M E4 ∙ ∙ ∙ ∙ ∙ ∙ ∙ + ∙ ∙ ∙ ∙ ∙ ∙ ∙F M E5 ╔═══════════════════════════════════════════════════════════╗F M E6 ∙ ║ ║∙ ∙F M E7 ║ ║F M E8 ∙ ║ This is an APPLICATION OBJECT. ║∙ ∙F M E9 ║ ║F M E10 ∙ ║ Type information here or greetings to your users. ║∙ ∙F M E11 ║ ║F M E12 ∙ ║ See Application menu to use as sign-on banner. ║∙ ∙F M E13 ║ ║F M E14 ∙ ║ ║∙ ∙F M E15 ║ ║F M E16 ∙ ╚═══════════════════════════════════════════════════════════╝∙ ∙F M E17F M E18 ∙ ∙ ∙ ∙ ∙ ∙ ∙ + ∙ ∙ ∙ ∙ ∙ ∙ ∙F M E19F M E20∙∙∙+∙∙∙∙1∙∙∙∙+∙∙∙∙2∙∙∙∙+∙∙∙∙3∙∙∙∙+∙∙∙∙4∙∙∙∙+∙∙∙∙5∙∙∙∙+∙∙∙∙6∙∙∙∙+∙∙∙∙7∙∙∙∙+∙∙∙∙F M EApp ║D:\...bt4w\CUSTMENU ║Row: 2 Col: 1 ║File:CUSTOMER ║F M EPrev/Next object: F3/F4 Move/Copy: F7/F8 Size: Shift-F7 Menus: F10F M EDesign Menu Item Generate Preset Exit 9:08:10 amF M E0 ∙ ∙ ∙ ╔═══════════════════════════════════════╗ ∙ ∙ ∙ ∙F M E╔════════════════║ Show item information ║═════════════════════╗F M E║ ADD ║ Change action ║ EXIT ║F M E╚════════════════║ Override assigned database or view ║═════════════════════╝F M E4 ∙ ∙ ∙ ║ Embed code ║ ∙ ∙ ∙ ∙F M E5 ╔═══════║ Bypass item on condition ║═══════════╗F M E6 ∙ ║ ║ Position record pointer ║ ║∙ ∙F M E7 ║ ║ Reassign index order ║ ║F M E8 ∙ ║ ║ Define logical window ║ ║∙ ∙F M E9 ║ ║ Write help text ║ ║F M E10 ∙ ║ Type i║ Assign message line prompt ║s. ║∙ ∙F M E11 ║ ╚═══════════════════════════════════════╝ ║F M E12 ∙ ║ See Application menu to use as sign-on banner. ║∙ ∙F M E13 ║ ║F M E14 ∙ ║ ║∙ ∙F M E15 ║ ║F M E16 ∙ ╚═══════════════════════════════════════════════════════════╝∙ ∙F M E17F M E18 ∙ ∙ ∙ ∙ ∙ ∙ ∙ + ∙ ∙ ∙ ∙ ∙ ∙ ∙F M E19F M E20∙∙∙+∙∙∙∙1∙∙∙∙+∙∙∙∙2∙∙∙∙+∙∙∙∙3∙∙∙∙+∙∙∙∙4∙∙∙∙+∙∙∙∙5∙∙∙∙+∙∙∙∙6∙∙∙∙+∙∙∙∙7∙∙∙∙+∙∙∙∙F M EApp ║D:\...bt4w\CUSTMENU ║ADD ║File:CUSTOMER ║F M EPrev/Next object:F3/F4 Prev/Next item:PgUp/PgDn Select:─┘ Work surface:EscFAA M PAAE(c) Interco International Page 45 PEAAF P MEDesign Menu Item Generate Preset Exit 9:08:20 amF M E0 ∙ ∙ ∙ ╔═══════════════════════════════════════╗ ∙ ∙ ∙ ∙F M E╔════════════════║ Show item information ║═════════════════════╗F M E║ ADD ║ Change action ║ EXIT ║F M E╚════════════════║ ╔══════════════════════════════════════════════╗═══════════╝F M E4 ∙ ∙ ∙ ║ ║ Text (no action) ║ ∙ ∙F M E5 ╔═══════║ ║ Open a menu ACTIVATE MENU ║═╗F M E6 ∙ ║ ║ ║ Browse (add, delete, edit) BROWSE ║ ║∙ ∙F M E7 ║ ║ ║ Edit form (add, delete, edit) EDIT ║ ║F M E8 ∙ ║ ║ ║ Display or print ║ ║∙ ∙F M E9 ║ ║ ║ Perform file operation ║ ║F M E10 ∙ ║ Type i║ ║ Run program ║ ║∙ ∙F M E11 ║ ╚══║ Quit ║ ║F M E12 ∙ ║ See Appli╚══════════════════════════════════════════════╝ ║∙ ∙F M E13 ║ ║F M E14 ∙ ║ ║∙ ∙F M E15 ║ ║F M E16 ∙ ╚═══════════════════════════════════════════════════════════╝∙ ∙F M E17F M E18 ∙ ∙ ∙ ∙ ∙ ∙ ∙ + ∙ ∙ ∙ ∙ ∙ ∙ ∙F M E19F M E20∙∙∙+∙∙∙∙1∙∙∙∙+∙∙∙∙2∙∙∙∙+∙∙∙∙3∙∙∙∙+∙∙∙∙4∙∙∙∙+∙∙∙∙5∙∙∙∙+∙∙∙∙6∙∙∙∙+∙∙∙∙7∙∙∙∙+∙∙∙∙F M EApp ║D:\...bt4w\CUSTMENU ║ADD ║File:CUSTOMER ║F M EPrev/Next item:PgUp/PgDn Change option: Select:─┘ Exit:EscF M EDesign Menu Item Generate Preset Exit 9:08:34 amF M E0 ∙ ∙ ∙ ╔═══════════════════════════════════════╗ ∙ ∙ ∙ ∙F M E╔══════════════════════════════════════════════════════════════════════════════╗F M E║ Append/Edit Via Form File ║F M E║ ║F M E║ FORMAT file: CUSTOMER Mode: APPEND ║F M E║ ║F M E║ FIELDS: ║F M E║ FILTER: ║F M E║ SCOPE: ║F M E║ FOR: ║F M E║ WHILE: ║F M E║ ║F M E║ Allow record ADD? YES Allow record EDIT? YES ║F M E║ Allow record DELETE? YES KEEP image on exit? NO ║F M E║ Display Edit MENU? YES Use PREVIOUS Edit form? NO ║F M E║ FOLLOW record after update? YES ║F M E║ ║F M E╚══════════════════════════════════════════════════════════════════════════════╝F M E18 ∙ ∙ ∙ ∙ ∙ ∙ ∙ + ∙ ∙ ∙ ∙ ∙ ∙ ∙F M E19F M E20∙∙∙+∙∙∙∙1∙∙∙∙+∙∙∙∙2∙∙∙∙+∙∙∙∙3∙∙∙∙+∙∙∙∙4∙∙∙∙+∙∙∙∙5∙∙∙∙+∙∙∙∙6∙∙∙∙+∙∙∙∙7∙∙∙∙+∙∙∙∙F M EApp ║D:\...bt4w\CUSTMENU ║ADD ║File:CUSTOMER ║F M EAccept: Ctrl-End Cancel: EscFAA M PAAEPage 46 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P MEDesign Menu Item Generate Preset Exit 9:09:37 amF M E0 ∙ ∙ ∙ ╔═══════════════════════════════════════╗ ∙ ∙ ∙ ∙F M E╔════════════════║ Show item information ║═════════════════════╗F M E║ ADD ║ Change action ║ EXIT ║F M E╚════════════════║ ╔══════════════════════════════════════════════╗═══════════╝F M E4 ∙ ∙ ∙ ║ ║ Text (no action) ║ ∙ ∙F M E5 ╔═══════║ ║ Open a menu ACTIVATE MENU ║═╗F M E6 ∙ ║ ║ ║ Browse (add, delete, edit) BROWSE ║ ║∙ ∙F M E7 ║ ║ ║ Edit form (add, delete, edit) EDIT ║ ║F M E8 ∙ ║ ║ ║ Display or print ║ ║∙ ∙F M E9 ║ ║ ║ ╔════════════════════════════════╗ ║ ║F M E10 ∙ ║ Type i║ ║ ║ Report REPORT FORM ║ ║ ║∙ ∙F M E11 ║ ╚══║ ║ Labels LABEL FORM ║ ║ ║F M E12 ∙ ║ See Appli╚══║ Display/list DISPLAY/LIST ║══════════╝ ║∙ ∙F M E13 ║ ╚════════════════════════════════╝ ║F M E14 ∙ ║ ║∙ ∙F M E15 ║ ║F M E16 ∙ ╚═══════════════════════════════════════════════════════════╝∙ ∙F M E17F M E18 ∙ ∙ ∙ ∙ ∙ ∙ ∙ + ∙ ∙ ∙ ∙ ∙ ∙ ∙F M E19F M E20∙∙∙+∙∙∙∙1∙∙∙∙+∙∙∙∙2∙∙∙∙+∙∙∙∙3∙∙∙∙+∙∙∙∙4∙∙∙∙+∙∙∙∙5∙∙∙∙+∙∙∙∙6∙∙∙∙+∙∙∙∙7∙∙∙∙+∙∙∙∙F M EApp ║D:\...bt4w\CUSTMENU ║REPORT ║File:CUSTOMER ║F M EPosition: Select: ─┘ Exit: EscF M EDesign Menu Item Generate Preset Exit 9:09:49 amF M E0 ∙ ∙ ∙ ╔═══════════════════════════════════════╗ ∙ ∙ ∙ ∙F M E╔══════════════════════════════════════════════════════════════════════════════╗F M E║ Print a Report ║F M E║ ║F M E║ FORM name: CUSTOMER ║F M E║ HEADING: ║F M E║ ║F M E║ Report format: FULL DETAIL ║F M E║ Heading format: PLAIN ║F M E║ Before printing: DO NOT EJECT ║F M E║ Send output to: ASK AT RUN TIME ║F M E║ ║F M E║ FILTER: ║F M E║ SCOPE: ║F M E║ FOR: ║F M E║ WHILE: ║F M E║ ║F M E╚══════════════════════════════════════════════════════════════════════════════╝F M E18 ∙ ∙ ∙ ∙ ∙ ∙ ∙ + ∙ ∙ ∙ ∙ ∙ ∙ ∙F M E19F M E20∙∙∙+∙∙∙∙1∙∙∙∙+∙∙∙∙2∙∙∙∙+∙∙∙∙3∙∙∙∙+∙∙∙∙4∙∙∙∙+∙∙∙∙5∙∙∙∙+∙∙∙∙6∙∙∙∙+∙∙∙∙7∙∙∙∙+∙∙∙∙F M EApp ║D:\...bt4w\CUSTMENU ║REPORT ║File:CUSTOMER ║F M EAccept: Ctrl-End Cancel: EscFAA M PAAE(c) Interco International Page 47 PEAAF P MEDesign Menu Item Generate Preset Exit 9:10:24 amF M E0 ∙ ∙ ∙ ╔═══════════════════════════════════════╗ ∙ ∙ ∙ ∙F M E╔════════════════║ Show item information ║═════════════════════╗F M E║ ADD ║ Change action ║ EXIT ║F M E╚════════════════║ ╔══════════════════════════════════════════════╗═══════════╝F M E4 ∙ ∙ ∙ ║ ║ Text (no action) ║ ∙ ∙F M E5 ╔═══════║ ║ Open a menu ACTIVATE MENU ║═╗F M E6 ∙ ║ ║ ║ Browse (add, delete, edit) BROWSE ║ ║∙ ∙F M E7 ║ ║ ║ Edit form (add, delete, edit) EDIT ║ ║F M E8 ∙ ║ ║ ║ Display or print ║ ║∙ ∙F M E9 ║ ║ ║ Perform file operation ║ ║F M E10 ∙ ║ Type i║ ║ Run program ║ ║∙ ∙F M E11 ║ ╚══║ Quit ║ ║F M E12 ∙ ║ See Appli╚══╔═══════════════════════════════════════╗═══╝ ║∙ ∙F M E13 ║ ║ Return to calling program RETURN ║ ║F M E14 ∙ ║ ║ Quit to DOS QUIT ║ ║∙ ∙F M E15 ║ ╚═══════════════════════════════════════╝ ║F M E16 ∙ ╚═══════════════════════════════════════════════════════════╝∙ ∙F M E17F M E18 ∙ ∙ ∙ ∙ ∙ ∙ ∙ + ∙ ∙ ∙ ∙ ∙ ∙ ∙F M E19F M E20∙∙∙+∙∙∙∙1∙∙∙∙+∙∙∙∙2∙∙∙∙+∙∙∙∙3∙∙∙∙+∙∙∙∙4∙∙∙∙+∙∙∙∙5∙∙∙∙+∙∙∙∙6∙∙∙∙+∙∙∙∙7∙∙∙∙+∙∙∙∙F M EApp ║D:\...bt4w\CUSTMENU ║EXIT ║File:CUSTOMER ║F M EPosition: Select: ─┘ Exit: EscF M EDesign Menu Item Generate Preset Exit 9:10:55 amF M E0 ∙ ╔═══════════════════════════════════════╗∙ ∙ ∙ ∙ ∙ ∙F M E╔════════║ Name and describe ║═════════════════════════════╗F M E║ ║ Override assigned database or view ║ EXIT ║F M E╚════════║ Write help text ║═════════════════════════════╝F M E4 ∙ ║ Modify display options ║∙ ∙ ∙ ∙ ∙ ∙F M E5 ║ Embed code ║═══════════════════╗F M E6 ∙ ║ Attach pull-down menus ║ ║∙ ∙F M E7 ║───────────────────────────────────────║ ║F M E8 ∙ ║ Save current menu ║ ║∙ ∙F M E9 ║ Put away current menu ║ ║F M E10 ∙ ║───────────────────────────────────────║our users. ║∙ ∙F M E11 ║ Clear work surface ║ ║F M E12 ∙ ╚═══════════════════════════════════════╝banner. ║∙ ∙F M E13 ║ ║F M E14 ∙ ║ ║∙ ∙F M E15 ║ ║F M E16 ∙ ╚═══════════════════════════════════════════════════════════╝∙ ∙F M E17F M E18 ∙ ∙ ∙ ∙ ∙ ∙ ∙ + ∙ ∙ ∙ ∙ ∙ ∙ ∙F M E19F M E20∙∙∙+∙∙∙∙1∙∙∙∙+∙∙∙∙2∙∙∙∙+∙∙∙∙3∙∙∙∙+∙∙∙∙4∙∙∙∙+∙∙∙∙5∙∙∙∙+∙∙∙∙6∙∙∙∙+∙∙∙∙7∙∙∙∙+∙∙∙∙F M EApp ║D:\...bt4w\CUSTMENU ║EXIT ║File:CUSTOMER ║F M EPrev/Next object:F3/F4 Change menu:^[FAA M PAAEPage 48 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P ME╔══════════════════════════════════════════════════════════════════════════════╗F M E║ ADD CHANGE REPORT EXIT ║F M E╚══════════════════════════════════════════════════════════════════════════════╝F M ECLASS EXAMPLE MENUF M ERecords Go To Exit 9:54:14 amF M ECUSTOMER INFORMATION FORMF M E┌─────────────────────────────────────────────────────────────────┐F M E│ │F M E│ Code LIMBER │F M E│ Name Limber Lumber Company │F M E│ Address 6789 Pinewood Way │F M E│ City Tall Tree STATE WA ZIP 67894 │F M E│ Phone (616) 434-8765 │F M E│ │F M E│ Contact Paul Bunyan │F M E│ │F M E│ Remarks MEMO │F M E│ │F M E└─────────────────────────────────────────────────────────────────┘F M E║D:\...bt4w\CUSTOMER ║Rec 1/6 ║File ║ ║FA*A* A A M PAAE(c) Interco International Page 49 PEAAF P M E┌────────────────────────┐F M E│ Send output to ... │F M E│────────────────────────│F M E│ CON: Console │F M E│ LPT1: Parallel port 1 │F M E│ LPT2: Parallel port 2 │F M E│ COM1: Serial port 1 │F M E│ FILE = REPORT.TXT │F M E└────────────────────────┘F M ECUSTOMER REPORTF M ECODE CUSTOMER CONTACTF M E▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒F M EBOISE Boise Cascade Ryan EllardF M E34 Third Avenue (313) 235-0987F M EInternational Falls,MN 34256F M EBRIGHTON Brighton Associates Bill BatesF M E123 South Surrey (214) 123-6789F M EMalibu Beach,CA 23456F M EGSA General Services Admin Ben ThomasF M E1551 Capitol Street (202) 345-7890F M EWashington,DC 23002FA*A* A(A( M PAAEPage 50 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P ME**********************************************************************F M E* Program......: MPDEFF M E* Author.......: This is an APPLICATION OBJECT.F M E* Date.........: 11-29-88F M E* Notice.......: Type information here or greetings to your users.F M E* dBASE Ver....: See Application menu to use as sign-on banner.F M E* Generated by.: APGEN version 1.0F M E* Description..: Customer Application ExampleF M E* Description..: Defines all menus in the systemF M E**********************************************************************F M E...F M EDEFINE WINDOW FullScr FROM 0,0 TO 24,79 NONEF M EDEFINE WINDOW Savescr FROM 0,0 TO 21,79 NONEF M EDEFINE WINDOW Helpscr FROM 0,0 TO 21,79 NONEF M EDEFINE WINDOW Browscr FROM 1,0 TO 21,79 NONEF M EIF gn_ApGen=1F M EDEFINE WINDOW Exit_App FROM 11,17 TO 15,62 DOUBLEF M EENDIFF M E*-- Window for pause message boxF M EDEFINE WINDOW Pause FROM 15,00 TO 19,79 DOUBLEF M EACTIVATE WINDOW FullScrF M E@ 24,00F M E@ 23,00 SAY "Loading..."F M ESET BORDER TO DOUBLEF M E*-- BarF M EDEFINE MENU CUSTMENU MESSAGE "CLASS MENU EXAMPLE"F M EDEFINE PAD PAD_1 OF CUSTMENU PROMPT "ADD" AT 1,9F M EON SELECTION PAD PAD_1 OF CUSTMENU DO ACT01F M EDEFINE PAD PAD_2 OF CUSTMENU PROMPT "CHANGE" AT 1,21F M EON SELECTION PAD PAD_2 OF CUSTMENU DO ACT01F M EDEFINE PAD PAD_3 OF CUSTMENU PROMPT "REPORT" AT 1,37F M EON SELECTION PAD PAD_3 OF CUSTMENU DO ACT01F M EDEFINE PAD PAD_4 OF CUSTMENU PROMPT "EXIT" AT 1,68F M EON SELECTION PAD PAD_4 OF CUSTMENU DO ACT01F M E?? "."F M E@ 23,00 CLEARF M ERETURNF M E*-- EOP: MPDEF.PRGFA'A' M PAAE(c) Interco International Page 51 PEAAF P E┌───────────────────┐F P E│ JOB COST SYSTEM │F P E└───────────────────┘F P MEDesign Menu Item Generate Preset Exit 9:14:25 amF M E0 ∙ ∙ ∙ ∙ ∙ ∙ ∙ + ∙ ∙ ∙ ∙ ∙ ∙ ∙F M E1F M E2 ∙ ∙ ∙ ∙ ∙ ∙ ∙ + ∙ ∙ ∙ ∙ ∙ ∙ ∙F M E3F M E4╔═══════════════════════════════════════════════════════════════════════════╗F M E5║ Data Entry Retrieval Other Options Exit ║F M E6╚═══════════════════════════════════════════════════════════════════════════╝F M E7 ╔════════════════╗ ╔═════════════╗ ╔════════════════════╗║F M E8 ║ Time Slips ║This ║ Reports ║ON OBJE║ Back up Data Files ║║∙ ∙F M E9 ║ Jobs ║ ║ Browse Data ║ ║ Copy Time to Lotus ║║F M E10║ Customers ║rmati║ Labels ║tings t║ Copy Emp to ASCII ║║∙ ∙F M E11║ Employees ║ ║ Invoices ║ ║ Go to DOS ║║F M E12║ Billing Rates ║catio╚═════════════╝s sign-╚════════════════════╝║∙ ∙F M E13║ Function Codes ║ ║F M E14╚════════════════╝ ║∙ ∙F M E15 ║ ║F M E16 ∙ ╚═══════════════════════════════════════════════════════════╝∙ ∙F M E17F M E18 ∙ ∙ ∙ ∙ ∙ ∙ ∙ + ∙ ∙ ∙ ∙ ∙ ∙ ∙F M E19F M E20∙∙∙+∙∙∙∙1∙∙∙∙+∙∙∙∙2∙∙∙∙+∙∙∙∙3∙∙∙∙+∙∙∙∙4∙∙∙∙+∙∙∙∙5∙∙∙∙+∙∙∙∙6∙∙∙∙+∙∙∙∙7∙∙∙∙+∙∙∙∙F M EApp ║D:\...bt4w\OTHEROPT ║Row: 8 Col:48 ║File:TIME ║F M EPrev/Next object: F3/F4 Move/Copy: F7/F8 Size: Shift-F7 Menus: F10F M EDesign Menu Item Generate Preset Exit 9:15:51 amF M E0 ∙ ∙ ∙ ∙ ∙ ∙ ∙ + ∙ ∙ ∙ ∙ ∙ ∙ ∙F M E1F M E2 ∙ ∙ ∙ ∙ ∙ ∙ ∙ + ∙ ∙ ∙ ∙ ∙ ∙ ∙F M E3F M E4╔═══════════════════════════════════════════════════════════════════════════╗F M E5║ Data Entry Retrieval Other Options Exit ║F M E6╚═══════════════════════════════════════════════════════════════════════════╝F M E7 ║ ╔═════════════╗ ║F M E8 ∙ ║ This ║ Reports ║ON OBJECT. ║∙ ∙F M E9 ║ ║ Browse Data ║ ║F M E10 ∙ ║ Type informati║ Labels ║tings to your users. ║∙ ∙F M E11 ║ ║ Invoices ║ ║F M E12 ∙ ║ See Applicatio╚═════════════╝s sign-on banner. ║∙ ∙F M E13 ║ ╔═══════════════════════╗ ║F M E14 ∙ ║ ║ Job Status Report ║ ║∙ ∙F M E15 ║ ║ Employee Phone Report ║ ║F M E16 ∙ ╚══════════════════════════════║ Customer Report ║════╝∙ ∙F M E17 ║ Job Report ║F M E18 ∙ ∙ ∙ ∙ ∙ ∙ ∙ ║ Function Code Listing ║∙ ∙ ∙F M E19 ╚═══════════════════════╝F M E20∙∙∙+∙∙∙∙1∙∙∙∙+∙∙∙∙2∙∙∙∙+∙∙∙∙3∙∙∙∙+∙∙∙∙4∙∙∙∙+∙∙∙∙5∙∙∙∙+∙∙∙∙6∙∙∙∙+∙∙∙∙7∙∙∙∙+∙∙∙∙F M EApp ║D:\...bt4w\REPORTS ║Row:14 Col:41 ║View:JOBSTAT ║F M EPrev/Next object: F3/F4 Move/Copy: F7/F8 Size: Shift-F7 Menus: F10FAA M PAAEPage 52 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P MEDesign List Item Generate Preset Exit 9:17:05 amF M E0 ∙ ∙ ∙ ∙ ∙ ∙ ∙ + ∙ ∙ ∙ ∙ ∙ ∙ ∙F M E1F M E2 ∙ ∙ ∙ ∙ ∙ ∙ ∙ + ∙ ∙ ∙ ∙ ∙ ∙ ∙F M E3F M E4╔═══════════════════════════════════════════════════════════════════════════╗F M E5║ Data Entry Retrieval Other Opt╔══════════════╗t ║F M E6╚════════════════════════════════════════════════════════║XXXXXXXXXXXXXX║═══╝F M E7 ║ ╔═════════════╗ ║ ║F M E8 ∙ ║ This ║ Reports ║ON OBJECT. ║ ║ ∙F M E9 ║ ║ Browse Data ║ ║ ║F M E10 ∙ ║ Type informati║ Labels ║tings to your user║ ║ ∙F M E11 ║ ║ Invoices ║ ║ ║F M E12 ∙ ║ See Applicatio╚═════════════╝s sign-on banner. ║ ║ ∙F M E13 ║ ╔═════════════════║ ║F M E14 ∙ ║ ║ Programming Dept║ ║ ∙F M E15 ║ ║ Billing Rates ║ ║F M E16 ∙ ╚══════════════════════════════╚═════════════════║ ║ ∙F M E17 ║ ║F M E18 ∙ ∙ ∙ ∙ ∙ ∙ ∙ + ∙ ∙ ∙ ║ ║ ∙F M E19 ╚══════════════╝F M E20∙∙∙+∙∙∙∙1∙∙∙∙+∙∙∙∙2∙∙∙∙+∙∙∙∙3∙∙∙∙+∙∙∙∙4∙∙∙∙+∙∙∙∙5∙∙∙∙+∙∙∙∙6∙∙∙∙+∙∙∙∙7∙∙∙∙+∙∙∙∙F M EApp ║D:\...bt4w\PROGFLDS ║Row: 6 Col:59 ║View:EMPPROG ║F M EPrev/Next object: F3/F4 Move: F7 Size: Shift-F7 Menus: F10F M EDesign Menu Item Generate Preset Exit 9:18:33 amF M E0 ∙ ∙ ∙ ∙ ∙ ∙ ∙ + ∙ ∙ ∙ ∙ ∙ ∙ ∙F M E1F M E2 ∙ ∙ ∙ ∙ ∙ ∙ ∙ + ∙ ∙ ∙ ∙ ∙ ∙ ∙F M E3F M E4╔═══════════════════════════════════════════════════════════════════════════╗F M E5║ Data Entry Retrieval Other Options Exit ║F M E6╚═══════════════════════════════════════════════════════════════════════════╝F M E7 ║ ╔════════════════════╗║F M E8 ∙ ║ This is an APPLICATION OBJE║ Back up Data Files ║║∙ ∙F M E9 ║ ║ Copy Time to Lotus ║║F M E10 ∙ ║ Type information here or greetings t║ Copy Emp to ASCII ║║∙ ∙F M E11 ║ ║ Go to DOS ║║F M E12 ∙ ║ See Application menu to use as sign-╚════════════════════╝║∙ ∙F M E13 ║ ║F M E14 ∙ ║ ║∙ ∙F M E15 ║ ║F M E16 ∙ ╚═══════════════════════════════════════════════════════════╝∙ ∙F M E17F M E18 ∙ ∙ ∙ ∙ ∙ ∙ ∙ + ∙ ∙ ∙ ∙ ∙ ∙ ∙F M E19F M E20∙∙∙+∙∙∙∙1∙∙∙∙+∙∙∙∙2∙∙∙∙+∙∙∙∙3∙∙∙∙+∙∙∙∙4∙∙∙∙+∙∙∙∙5∙∙∙∙+∙∙∙∙6∙∙∙∙+∙∙∙∙7∙∙∙∙+∙∙∙∙F M EApp ║D:\...bt4w\OTHEROPT ║Row: 8 Col:48 ║File:TIME ║F M EPrev/Next object: F3/F4 Move/Copy: F7/F8 Size: Shift-F7 Menus: F10FAA M PAAE(c) Interco International Page 53 PEAAF P MEDesign Menu Item Generate Preset Exit 9:19:21 amF M E0 ∙ ∙ ∙ ╔═══════════════════════════════════════╗ ∙ ∙ ∙ ∙F M E1 ║ Show item information ║F M E2 ∙ ∙ ∙ ║ Change action ║ ∙ ∙ ∙ ∙F M E3 ║ ╔══════════════════════════════════════════════╗F M E4╔═══════════════║ ║ Text (no action) ║═════════╗F M E5║ Data Entry ║ ║ Open a menu ACTIVATE MENU ║ Exit ║F M E6╚═══════════════║ ║ Browse (add, delete, edit) BROWSE ║═════════╝F M E7 ║ ║ ║ Edit form (add, delete, edit) EDIT ║╗║F M E8 ∙ ║ ║ ║ Display or print ║║║∙ ∙F M E9 ║ ║ ║ Perform file operation ║║║F M E10 ∙ ║ Type i║ ║ Run program ║║║∙ ∙F M E11 ║ ╚══║ ╔═══════════════════════════════════════╗ ║║║F M E12 ∙ ║ See Appli╚══║ Do dBASE program DO ║═══╝╝║∙ ∙F M E╔══════════════════════════════════════════════════════════════════════════════╗F M E║ ║F M E║ Program: BACKUP ║F M E║ Parameters: ║F M E║ ║F M E╚══════════════════════════════════════════════════════════════════════════════╝F M E19F M E20∙∙∙+∙∙∙∙1∙∙∙∙+∙∙∙∙2∙∙∙∙+∙∙∙∙3∙∙∙∙+∙∙∙∙4∙∙∙∙+∙∙∙∙5∙∙∙∙+∙∙∙∙6∙∙∙∙+∙∙∙∙7∙∙∙∙+∙∙∙∙F M EApp ║D:\...bt4w\OTHEROPT ║ Back up Data Fil║File:TIME ║F M EAccept: Ctrl-End Cancel: EscF M EDesign Menu Item Generate Preset Exit 9:19:59 amF M E0 ∙ ∙ ∙ ╔═══════════════════════════════════════╗ ∙ ∙ ∙ ∙F M E1 ║ Show item information ║F M E2 ∙ ∙ ∙ ║ Change action ╔════════════════════════════════════════╗F M E3 ║ ╔════════════════║ File copy COPY FILE ║F M E4╔═══════════════║ ║ Text (no acti║ Add records from file APPEND FROM ║F M E5║ Data Entry ║ ║ Open a menu ║ Copy records to file COPY TO ║F M E6╚═══════════════║ ║ Browse (add, ║ Substitute field values REPLACE ║F M E7 ║ ║ ║ Edit form (ad║ Mark records for deletion DELETE ║F M E8 ∙ ║ ║ ║ Display or pr║ Unmark records RECALL ║F M E9 ║ ║ ║ Perform file ║ Discard marked records PACK ║F M E10 ∙ ║ Type i║ ║ Run program ║ Generate index INDEX ON ║F M E11 ║ ╚══║ Quit ║ Reindex database REINDEX ║F M E12 ∙ ║ See Appli╚════════════════║ Physically sort database SORT TO ║F M E13 ║ ║ Import foreign file IMPORT ║F M E14 ∙ ║ ║ Export foreign file EXPORT ║F M E15 ║ ╚════════════════════════════════════════╝F M E16 ∙ ╚═══════════════════════════════════════════════════════════╝∙ ∙F M E17F M E18 ∙ ∙ ∙ ∙ ∙ ∙ ∙ + ∙ ∙ ∙ ∙ ∙ ∙ ∙F M E19F M E20∙∙∙+∙∙∙∙1∙∙∙∙+∙∙∙∙2∙∙∙∙+∙∙∙∙3∙∙∙∙+∙∙∙∙4∙∙∙∙+∙∙∙∙5∙∙∙∙+∙∙∙∙6∙∙∙∙+∙∙∙∙7∙∙∙∙+∙∙∙∙F M EApp ║D:\...bt4w\OTHEROPT ║ Copy Time to Lot║File:TIME ║F M EPosition: Select: ─┘ Exit: EscFAA M PAAEPage 54 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P MEDesign Menu Item Generate Preset Exit 9:20:13 amF M E0 ∙ ∙ ∙ ╔═══════════════════════════════════════╗ ∙ ∙ ∙ ∙F M E1 ║ Show item information ║F M E2 ∙ ∙ ∙ ║ Change action ╔════════════════════════════════════════╗F M E3 ║ ╔════════════════║ File copy COPY FILE ║F M E4╔═══════════════║ ║ Text (no acti║ Add records from file APPEND FROM ║F M E5║ Data Entry ║ ║ Open a menu ║ Copy records to file COPY TO ║F M E╔══════════════════════════════════════════════════════════════════════════════╗F M E║ (TO file will be overwritten) ║F M E║ ║F M E║ Copy records TO file/array: TIME.WKS ║F M E║ Of TYPE: WKS ║F M E║ ║F M E║ DELIMITER (other than ") for delimited type: ║F M E║ ║F M E║ FIELDS: ║F M E║ SCOPE: ║F M E║ FOR: ║F M E║ WHILE: ║F M E║ ║F M E╚══════════════════════════════════════════════════════════════════════════════╝F M E20∙∙∙+∙∙∙∙1∙∙∙∙+∙∙∙∙2∙∙∙∙+∙∙∙∙3∙∙∙∙+∙∙∙∙4∙∙∙∙+∙∙∙∙5∙∙∙∙+∙∙∙∙6∙∙∙∙+∙∙∙∙7∙∙∙∙+∙∙∙∙F M EApp ║D:\...bt4w\OTHEROPT ║ Copy Time to Lot║File:TIME ║F M EAccept: Ctrl-End Cancel: EscF M EDesign Menu Item Generate Preset Exit 9:21:59 amF M E0 ∙ ∙ ∙ ╔═══════════════════════════════════════╗ ∙ ∙ ∙ ∙F M E1 ║ Show item information ║F M E2 ∙ ∙ ∙ ║ Change action ║ ∙ ∙ ∙ ∙F M E3 ║ ╔══════════════════════════════════════════════╗F M E4╔═══════════════║ ║ Text (no action) ║═════════╗F M E5║ Data Entry ║ ║ Open a menu ACTIVATE MENU ║ Exit ║F M E6╚═══════════════║ ║ Browse (add, delete, edit) BROWSE ║═════════╝F M E7 ║ ║ ║ Edit form (add, delete, edit) EDIT ║╗║F M E8 ∙ ║ ║ ║ Display or print ║║║∙ ∙F M E9 ║ ║ ║ Perform file operation ║║║F M E10 ∙ ║ Type i║ ║ Run program ║║║∙ ∙F M E11 ║ ╚══║ ╔═══════════════════════════════════════╗ ║║║F M E12 ∙ ║ See Appli╚══║ Do dBASE program DO ║═══╝╝║∙ ∙F M E13 ║ ║ Execute BATCH process ║ ║F M E14 ∙ ║ ║ Insert dBASE code ║ ║∙ ∙F M E15 ║ ║ Run DOS program RUN ║ ║F M E16 ∙ ╚═════════════║ Load/call binary file LOAD/CALL ║═════╝∙ ∙F M E17 ║ Play back macro PLAY MACRO ║F M E18 ∙ ∙ ∙ ∙ ╚═══════════════════════════════════════╝ ∙ ∙ ∙F M E19F M E20∙∙∙+∙∙∙∙1∙∙∙∙+∙∙∙∙2∙∙∙∙+∙∙∙∙3∙∙∙∙+∙∙∙∙4∙∙∙∙+∙∙∙∙5∙∙∙∙+∙∙∙∙6∙∙∙∙+∙∙∙∙7∙∙∙∙+∙∙∙∙F M EApp ║D:\...bt4w\OTHEROPT ║ Go to DOS ║File:TIME ║F M EPosition: Select: ─┘ Exit: EscFAA M PAAE(c) Interco International Page 55 PEAAF P MEDesign Menu Item Generate Preset Exit 9:22:15 amF M E╔══════════════════════════════════════════════════════════════════════════════╗F M E║RUN COMMAND ║F M E║ ║F M E║ ║F M E║ ║F M E║ ║F M E║ ║F M E║ ║F M E║ ║F M E║ ║F M E║ ║F M E║ ║F M E║ ║F M E║ ║F M E║ ║F M E║ ║F M E║ ║F M E║ ║F M E║ ║F M E║ ║F M E╚══════════════════════════════════════════════════════════════════════════════╝F M EApp ║D:\...bt4w\OTHEROPT ║Row: 1 Col: 1 ║File:TIME ║F M EAccept: Ctrl-End Cancel: EscF M EDesign Menu Item Generate Preset Exit 9:23:14 amF M E0 ∙ ╔═══════════════════════════════════════╗∙ ∙ ∙ ∙ ∙ ∙F M E1 ║ Name and describe ║F M E2 ∙ ║ Override assigned database or view ║∙ ∙ ∙ ∙ ∙ ∙F M E3 ║ Write help text ║F M E4╔═══════║ Modify display options ║═══════════════════════════╗F M E5║ Data ║ Embed code ║ther Options Exit ║F M E6╚═══════║ ╔══════════╗-down menus ║═══════════════════════════╝F M E7 ║──║ Before ║─────────────────────────║ ║F M E8 ∙ ║ ║ After ║t menu ║ ║∙ ∙F M E9 ║ ╚══════════╝rrent menu ║ ║F M E10 ∙ ║───────────────────────────────────────║our users. ║∙ ∙F M E11 ║ Clear work surface ║ ║F M E12 ∙ ╚═══════════════════════════════════════╝banner. ║∙ ∙F M E13 ║ ║F M E14 ∙ ║ ║∙ ∙F M E15 ║ ║F M E16 ∙ ╚═══════════════════════════════════════════════════════════╝∙ ∙F M E17F M E18 ∙ ∙ ∙ ∙ ∙ ∙ ∙ + ∙ ∙ ∙ ∙ ∙ ∙ ∙F M E19F M E20∙∙∙+∙∙∙∙1∙∙∙∙+∙∙∙∙2∙∙∙∙+∙∙∙∙3∙∙∙∙+∙∙∙∙4∙∙∙∙+∙∙∙∙5∙∙∙∙+∙∙∙∙6∙∙∙∙+∙∙∙∙7∙∙∙∙+∙∙∙∙F M EApp ║D:\...bt4w\MAINBAR ║Data Entry ║File:TIME ║F M EPosition: Select: ─┘ Exit: EscFAA M PAAEPage 56 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P MEDesign Menu Item Generate Preset Exit 9:23:26 amF M E╔══════════════════════════════════════════════════════════════════════════════╗F M E║SET NEAR ON ║F M E║@ 0,0 ║F M E║TEXT ║F M E║ ║F M E║ J O B C O S T S Y S T E M ║F M E║ENDTEXT ║F M E║@ 1,20 to 3,60 DOUBLE ║F M E║ ║F M E║ ║F M E║ ║F M E║ ║F M E║ ║F M E║ ║F M E║ ║F M E║ ║F M E║ ║F M E║ ║F M E║ ║F M E║ ║F M E╚══════════════════════════════════════════════════════════════════════════════╝F M EApp ║D:\...bt4w\MAINBAR ║Row: 1 Col: 1 ║File:TIME ║F M EAccept: Ctrl-End Cancel: EscF M EDesign Menu Item Generate Preset Exit 9:26:43 amF M E0 ∙ ∙ ∙ ╔═══════════════════════════════════════╗ ∙ ∙ ∙ ∙F M E1 ║ Show item information ║F M E2 ∙ ∙ ∙ ║ Change action ║ ∙ ∙ ∙ ∙F M E3 ║ Override assigned database or view ║F M E╔══════════════════════════════════════════════════════════════════════════════╗F M E║ ║F M E║ These values are currently assigned to the menu : ║F M E║ ║F M E║ Database/view: TIME ║F M E║ Set INDEX to: ║F M E║ ORDER: ║F M E║ ║F M E║ For this item you may use values: ENTERED BELOW ║F M E║ ║F M E║ Database/view: JOBSTAT.QBE ║F M E║ Set INDEX to: ║F M E║ ORDER: ║F M E║ ║F M E╚══════════════════════════════════════════════════════════════════════════════╝F M E19 ╚═══════════════════════╝F M E20∙∙∙+∙∙∙∙1∙∙∙∙+∙∙∙∙2∙∙∙∙+∙∙∙∙3∙∙∙∙+∙∙∙∙4∙∙∙∙+∙∙∙∙5∙∙∙∙+∙∙∙∙6∙∙∙∙+∙∙∙∙7∙∙∙∙+∙∙∙∙F M EApp ║D:\...bt4w\REPORTS ║ Job Status Repor║View:JOBSTAT ║F M EPrev/Next item: PgUp/PgDn Accept: Ctrl-End Cancel: EscFAA M PAAE(c) Interco International Page 57 PEAAF P E┌───────────────────┐F P E│ APGEN SUMMARY │F P E└───────────────────┘F P EWith the addition of the APGEN Applications GeneratorF P Epowerful systems can be created without in depth knowledge ofF P EdBase Commands. Experienced programmers should use APGEN toF P Ecreate as much of the system as possible. When hand coding isF P Erequired it should be embeded at the appropriate point in theF P EAPGEN designer screens.F P EExperienced programmers should focus on learning theF P ETemplate Language. Templates can be modified to produce theF P Edesired results from the design screens. Real power will beF P Ederived from the modifications of these templates.F P E//F P E// Module Name: AD_APND.COD - Menu_Act = 7F P E// Selectors : Appnd_from, Appnd_type, For_ExprF P E// Description: to issue the dBASE APPEND commandF P E// Syntax : APPEND FROM <expFN>/?/ARRAY <array name>F P E// [FOR <expL>]F P E// [ [TYPE] DBASEII / DIF / FW2 / RPD / SDF /F P ESYLK / WKSF P E// [DELIMITED [WITH BLANK/<delimiter>]] ]F P E//F P Elc_say='Appending records from file {if Appnd_type == 5}ARRAYF P E{endif}{Appnd_from}'F P EDO info_box WITH lc_sayF P E//F P ESET TALK ONF P EAPPEND FROM {if Appnd_type == 5}ARRAY {endif}{Appnd_from} \F P E{if For_Expr} FOR {For_Expr}{endif}\F P E{if Appnd_type && Appnd_type != 5 then} TYPE {endif}\F P E{ case Appnd_type of}F P E{ 0: // insert carriage return for DBF}F P E{ 1:}dBASEIIF P E{ 2:}FW2F P E{ 3:}RPDF P E{ 4:}DELIMITED {if Appl_Delim}WITH {Appl_Delim}{endif}F P E{ 5: // insert carriage return for ARRAY}F P E{ 6:}SDFF P E{ 7:}DIFF P E{ 8:}SYLKF P E{ 9:}WKSF P E{ endcase}F P E// end of if Appnd_typeF P ESET TALK OFFF P E//F P E// EOP AD_APND.CODFA"A" P EPage 58 (c) Interco InternationalPEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E┌─────────────────────────────────────────────┐F P E│ PROGRAMMING TOOLS, DATA TRANSFERS AND SQL │F P E└─────────────────────────────────────────────┘F P E┌───────────────────────────┐F P E│ PROGRAMMING UTILITIES │F P E└───────────────────────────┘F P E┌────────────────────────────────────────────────────┐F P E│ Automatic Compiling to Encode and Speed Programs │F P E└────────────────────────────────────────────────────┘F P EdBase IV provides automatic conversion between the ControlF P ECenter design screens and the executable machine language thatF P Ethe computer understands. Below is a listing of files included inF P Ethe JOB COST SYSTEM. There are three categories of files: DesignF P E(produced from the CC design screens), Source (produced by theF P Etemplates) and Compiled (produced by the compiler). Only theF P ECompiled files are required for the execution of the systemF P Eprograms.F P EIf we try to read an object file with the TYPE command, weF P Eget encoded information. This would prohibit the unauthorizedF P Emodification of distributed programs. As such this featureF P Eprovides security to your systems.F P ECompiling also increases the execution speed of yourF P Eprograms by skipping unnecessary statements such as comments whenF P Ethe program is run.FA*A* P E(c) Interco International Page 59PEAAF P MEPROGRAMSF M EDESIGN SOURCE COMPILEDF M E===================== ===================== =====================F M ECUSTEXAM APP 1029 CUSTEXAM PRG 16780 CUSTEXAM DBO 15764F M ECUSTOMER APP 1078 CUSTOMER PRG 16212 CUSTOMER DBO 14200F M EEMP APP 867 EMP PRG 15928 EMP DBO 14092F M EEMPRATE APP 899 EMPRATE PRG 7840 EMPRATE DBO 6208F M EFUNCODE APP 1035 FUNCODE PRG 15082 FUNCODE DBO 13132F M EJOB APP 852 JOB PRG 14839 JOB DBO 13048F M EJOBMENU APP 927 JOBMENU PRG 21078 JOBMENU DBO 20388F M ETIME APP 855 TIME PRG 14566 TIME DBO 12804F M EREPORTSF M EDESIGN SOURCE COMPILEDF M E===================== ===================== =====================F M ECUSTOMER FRM 2558 CUSTOMER FRG 4366 CUSTOMER FRO 4332F M EEMP FRM 2947 EMP FRG 4670 EMP FRO 4728F M EINVOICE FRM 4143 INVOICE FRG 7198 INVOICE FRO 8012F M EJOBSTAT FRM 5167 JOBSTAT FRG 9225 JOBSTAT FRO 10684F M ETIME FRM 2292 TIME FRG 10181 TIME FRO 12176F M ELABELSF M EDESIGN SOURCE COMPILEDF M E===================== ===================== =====================F M ECUSTOMER LBL 1445 CUSTOMER LBG 5199 CUSTOMER LBO 5436F M EEMP LBL 1407 EMP LBG 4801 EMP LBO 4860F M ESCREEN FORMSF M EDESIGN SOURCE COMPILEDF M E===================== ===================== =====================F M ECUSTOMER SCR 2336 CUSTOMER FMT 1950 CUSTOMER FMO 1744F M EEMP SCR 3255 EMP FMT 2323 EMP FMO 2256F M EEMPRATE SCR 1018 EMPRATE FMT 1405 EMPRATE FMO 1068F M EFUNCODE SCR 812 FUNCODE FMT 1369 FUNCODE FMO 1000F M EJOB SCR 2081 JOB FMT 1699 JOB FMO 1492F M ETIME SCR 1695 TIME FMT 1931 TIME FMO 1720F M EQUERIES AND UPDATESF M EDESIGN SOURCE COMPILEDF M E===================== ===================== =====================F M EEMPPROG QBE 3373 EMPPROG QBE 3373 EMPPROG QBO 260F M EEMPRATE QBE 4316 EMPRATE QBE 4316 EMPRATE QBO 1080F M EINVOICE QBE 5804 INVOICE QBE 5804 INVOICE QBO 980F M EJOBHRSRT QBE 5567 JOBHRSRT QBE 5567 JOBHRSRT QBO 1976F M EMARK UPD 3321 MARK UPD 3321 MARK DBO 352F M EUNMARK UPD 3296 UNMARK UPD 3296 UNMARK DBO 368FA!A! M PAAEPage 60 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E┌───────────────────────────────────────────────────────────────┐F P E│ Runtime/Professional Compiler for Royalty Free DistributionF P E│F P E└───────────────────────────────────────────────────────────────┘F P EUnder Runtime the program file are used in their compiledF P E.DBO/.FMO etc. formats. If you have 50 compiled files each canF P Ebe distributed to the user or by using the DBLINK utility theyF P Ecan be gathered into one .DBO file. By using the BUILD utilityF P Eall programs in a system can be compiled and copied along withF P Ethe necessary Runtime files in one operation. Remember thatF P Ethe Runtime files must be given to the customer.F P EThe Professional Compiler will gather all of theseF P Eelements into one executable file (.EXE) and requires theF P Edistribution of only this one file. There is no requirementF P Efor the Runtime files. By buying the developers editionF P Emanagement can choose between these two options withoutF P Eadditional cost.FA*A* A)A) P E(c) Interco International Page 61PEAAF P MEBuild Options Exit 08:22:57 pmF M E╔══════════════════════════════╗F M E║ Compile ║F M E║ Link yes ║F M E║ Output destination ║F M E║ Perform BUILD ║F M E╚══════════════════════════════╝F M EBUILD ║<D:>║ ║Opt: 1/4 ║ ║F M EBuild Options Exit 08:24:13 pmF M E╔══════════════════════════════════════════╗F M E║ Default program file extension .PRG ║F M E║ Search for new functions no ║F M E║ Accept only RUNTIME commands no ║F M E║ Include file types ║F M E║──────────────────────────────────────────║F M E║ Print messages to Screen ║F M E║ Copy runtime yes ║F M E║ Locate runtime source directory ║F M E╚══════════════════════════════════════════╝FA&A& M PAAEPage 62 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E┌─────────────────────────────────────────────────┐F P E│ The Editor - Enhanced Support for Programming │F P E└─────────────────────────────────────────────────┘F P EdBase IV provides a text editor used to write and editF P Eprograms. It can be activated from the control center byF P Eselecting APPLICATIONS then dBASE PROGRAM. It can also beF P Eactivated at the dot prompt by entering MODIFY COMMAND. ThisF P Etext editor is normally used when using memo fields. TheF P Eeditor will now handle up to 32,000 lines and provides blockF P Ecommands as well as other word processing features. A newF P Efeature allows you to link into the dBASE IV Debugger and runF P Eyour new program. To do so select EXIT from the Editor MenuF P Eand choose Debug Program. This is recommended for theF P Econversion of dBase III programs.F P MELayout Words Go To Print Exit 8:01:58 pmF M E╔════════════════════════════════╗∙····4 ···∙··· 5····∙· ··6···· ····7·· ·∙·····F M E║ Modify a different program ║F M E║ Edit description of program ║F M E║ Save this program ║F M E╚════════════════════════════════╝F M EProgram ║D:\...bt4w\<NEW> ║Line:1 Col:1 ║ ║ InsF M ELayout Words Go To Print Exit 8:02:47 pmF M E[···∙··· ╔════════════════════════════════╗·∙··· 5····∙· ··6···· ····7·· ·∙·····F M E║ Style ║F M E║ Display ║F M E║ Position ║F M E║ Modify ruler ║F M E║ Hide ruler NO ║F M E║ Enable automatic indent YES ║F M E║────────────────────────────────║F M E║ Add line ║F M E║ Remove line ║F M E║ Insert page break ║F M E║ Write/read text file ║F M E╚════════════════════════════════╝FA"A" M PAAE(c) Interco International Page 63 PEAAF P MELayout Words Go To Print Exit 8:03:20 pmF M E[···∙··· 1····∙· ╔═════════════════════════════════════════╗···· ····7·· ·∙·····F M E║ Go to line number {1} ║F M E║─────────────────────────────────────────║F M E║ Forward search {} ║F M E║ Backward search {} ║F M E║ Replace {} ║F M E║ Match capitalization NO ║F M E╚═════════════════════════════════════════╝F M EProgram ║D:\...bt4w\<NEW> ║Line:1 Col:1 ║ ║ InsF M ELayout Words Go To Print Exit 8:03:59 pmF M E[···∙··· 1····∙· ··2···· ╔═══════════════════════════════════╗·· ····7·· ·∙·····F M E║ Begin printing ║F M E║ Eject page now ║F M E║ Line numbers NO ║F M E║───────────────────────────────────║F M E║ Use print form {} ║F M E║ Save settings to print form ║F M E║───────────────────────────────────║F M E║ Destination ║F M E║ Control of printer ║F M E║ Output options ║F M E║ Page dimensions ║F M E╚═══════════════════════════════════╝F M EProgram ║D:\...bt4w\<NEW> ║Line:1 Col:1 ║ ║ InsFA*A* A$A$ M PAAEPage 64 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P MELayout Words Go To Print Exit 8:04:33 pmF M E[···∙··· 1····∙· ··2···· ····3·· ╔═════════════════════════════╗ ····7·· ·∙·····F M E║ Save changes and exit ║F M E║ Abandon changes and exit ║F M E║─────────────────────────────║F M E║ Run program ║F M E║ Debug program ║F M E╚═════════════════════════════╝F M EProgram ║D:\...bt4w\<NEW> ║Line:1 Col:1 ║ ║ InsFA*A* A(A( M PAAE(c) Interco International Page 65 PEAAF P E┌───────────────────────────────────────┐F P E│ The Debugger - Professional Support │F P E└───────────────────────────────────────┘F P EThe Debugging utility which is available on all dBASE IVF P Eeditions provides an interactive way to isolate errors in handF P Ecoded programs. The debugger can be activated as mentionedF P Eabove from the text editor. It can be activated from the dotF P Eprompt by SET TRAP ON or DEBUG <program name>. To enter theF P Edebug mode while a program is running press ESC.F P ME┌─── D:\DBSYS\CLASSES\BT4W\TEST.PR┌────────────────────────────────────────────┐F M E│ 1 ? 'Hi there!' │ --- Debug Commands --- │F M E│ │ │F M E│ │ B - Change Breakpoint entries. │F M E│ │ D - Change Display entries. │F M E│ │ E - Edit program file. │F M E│ │ L - Continue from given line. │F M E│ │ [n]N - As 'S' but on same or above level.│F M E│ │ P - Show program traceback info. │F M E│ │ Q - Quit debugger. │F M E│ │ R - Run until interrupt or error. │F M E│ │ [n]S - Execute next statement. │F M E└─────────────────────────────────│ X - Exit to DOT Prompt. │F M E┌─── DISPLAY ─────────────────────│ [n] ─┘ - Repeat last step or next. │F M E│ : │ [n] ^ - Show previous line. │F M E│ : │ [n] v - Show next line. │F M E│ : │ F1 - Toggle Command Help On/Off. │F M E│ : │ F9 - Show user screen. │F M E└─────────────────────────────────└────────────────────────────────────────────┘F M E┌─── DEBUGGER ─────────────────────────────────────────────────────────────────┐F M E│Work Area: 1 Database file: Program file: test.prg │F M E│Record: 0 Master Index: Procedure: TEST │F M E│ACTION: Current line: 1 │F M E└──────────────────────────────────────────────────────────────────────────────┘FA*A* A%A% M PAAEPage 66 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E┌────────────────────────────────────┐F P E│ Step IVward - Conversion Utility │F P E└────────────────────────────────────┘F P EWith Step IVward programs written in Clipper, Foxbase andF P EQuicksilver can be converted to dBASE IV.F P ME╔══════════════════════════════════════════════════════════════════════════════╗F M E║ ║F M E║ Copyright (c) Ashton-Tate Corporation. All Rights Reserved. ║F M E║ Step IVward and Ashton-Tate are trademarks of Ashton-Tate ║F M E║ Corporation. ║F M E║ ║F M E║ You may use the software and printed materials in the Step IVward ║F M E║ package under the terms of the Software License Agreement; please ║F M E║ read it. In summary, Ashton-Tate grants you a paid-up, ║F M E║ non-transferable, personal license to use Step IVward on one ║F M E║ computer work station. You do not become the owner of the ║F M E║ package nor do you have the right to copy (except permitted ║F M E║ backups of the software) or alter the software or printed ║F M E║ materials. You are legally accountable for any violation of the ║F M E║ License Agreement and copyright, trademark, or trade secret law. ║F M E║ ║F M E║ ║F M E╚══════════════════════════════════════════════════════════════════════════════╝F M EPress Return to assent to the License AgreementF M ESetup Options Print Translate ExitF M E╔══════════════════════╗F M E║ Input filename ║F M E║ Output filename ║F M E║──────────────────────║F M E║ Programmer's name ║F M E║ Copyright notice ║F M E╚══════════════════════╝F M EStep IVward ║ V1.0 ║ ║ ║FAA M PAAE(c) Interco International Page 67 PEAAF P MESetup Options Print Translate ExitF M E╔═════════════════════════════════╗F M E║ Suppress file headers NO ║F M E║ Suppress file footer NO ║F M E║─────────────────────────────────║F M E║ Process files tree NO ║F M E║ Prompt before each file NO ║F M E║ Comment old source NO ║F M E╚═════════════════════════════════╝F M EStep IVward ║ V1.0 ║ ║ ║F M ESetup Options Print Translate ExitF M E╔════════════════════════════╗F M E║ Printer OFF ║F M E║ Control of printer ║F M E║ Output options ║F M E║ Destination ║F M E╚════════════════════════════╝F M EStep IVward ║ V1.0 ║ ║ ║FA*A* A!A! M PAAEPage 68 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P MESetup Options Print Translate ExitF M E╔═════════════════════════════════════════════════════╗F M E║ Begin translation ║F M E║ Language to convert from Clipper ║F M E║ Suppress display during translation NO ║F M E╚═════════════════════════════════════════════════════╝F M EStep IVward ║ V1.0 ║ ║ ║FA*A* A(A( M PAAE(c) Interco International Page 69 PEAAF P E┌────────────────────────────┐F P E│ PROGRAMMING FOR NETWORKS │F P E└────────────────────────────┘F P EThe main concern for use of databases on local areaF P Enetworks is the integrity of your data files. Local areaF P Enetwork operating software works in conjunction with DOS toF P Esignal that a file or record is in use by another user. dBaseF P EIV provides for signaling to the operating system when a lockF P Eis made to a file or record and reacts to operating systemF P Emessages. Unlike earlier versions on dBASE this signaling isF P Eautomatically included when dBASE IV executes a program. InF P Eother words single-user programs written in dBASE II,III orF P EIII Plus can be run on local area networks once they have beenF P Econverted to IV. This is a primary consideration for those whoF P Eare considering the move to a local area network. RememberF P Ethat you must install dBASE IV as MULTIUSER with DBSETUPF P Ebefore networking will work.F P E┌────────────────┐F P E│ Installation │F P E└────────────────┘F P EInstallation is straight forward using DBSETUP from DOS.F P MEHardware setup 10:30:48 amF M E╔══════════════════════════════════════════╗F M E║ Multi-user installation Yes ║F M E║ Display mode ║F M E║ Optimize color display ║F M E║ Printers ║F M E╚══════════════════════════════════════════╝F M E╔═══════════════════════════════════════════════╗F M E║ ║F M E║ Please specify your hardware environment. ║F M E║ Use Ctrl-End to save your settings and ║F M E║ proceed, or Esc to cancel this operation. ║F M E║ ║F M E╚═══════════════════════════════════════════════╝F M EdBSETUP ║D:\dbsys\classes\BT4W ║Opt: 1/4 ║Hard Disk ║FA*A* A(A( M PAAEPage 70 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E┌───────────┐F P E│ Protect │F P E└───────────┘F P EProtect can be called from the Control Center Tools Menu.F P EYou will be allowed to password protect your system, encryptF P Edata files and assign passwords and access levels to eachF P Euser. NOTE: Protect can be used in either single or multiuserF P Emodes.F P MECatalog Tools Exit 10:32:33 amF M E╔══════════════════╗ASE IV CONTROL CENTERF M E║ Macros ║F M E║ Import ║:\DBSYS\CLASSES\BT4W\JOBCOST.CATF M E║ Export ║F M EData ║ DOS utilities ║Forms Reports Labels ApplicationsF M E╔═════════║ Protect data ║═════════╦════════════╦════════════╦════════════╗F M E║ <create║ Settings ║create> ║ <create> ║ <create> ║ <create> ║F M E║─────────╔══════════════════════════════════════════════════════════╗────────║F M E║ CUSTOME║ ║STEXAM ║F M E║ EMP ║ The dBASE protect utility permanently assigns passwords ║STOMER ║F M E║ EMPRATE║ to dBASE and your data. ║P ║F M E║ FUNCODE║ ║PRATE ║F M E║ JOB ║ Proceed Cancel ║NCODE ║F M E║ TIME ║ ║B ║F M E║ ╚══════════════════════════════════════════════════════════╝BMENU ║F M E║ ║ *UNMARK ║ ║ JOBSTAT ║ ║ TIME ║F M E╚════════════╩════════════╩════════════╩════════════╩════════════╩════════════╝F M EFile: New fileF M EDescription: Press ENTER on <create> to create a new fileF M ESelect option and press ENTER, or press first letter of desired optionF M E10:33:21 amF M E╔═════════════════════════════════════════════════════════════════════════╗F M E║ ║F M E║ dBASE IV Password Security System ║F M E║ ║F M E║ Enter password ║F M E║ ║F M E╚═════════════════════════════════════════════════════════════════════════╝FA*A* A A M PAAE(c) Interco International Page 71 PEAAF P MEUsers Files Reports Exit 10:34:05 amF M E╔═════════════════════════════════════════════════╗F M E║ Login name ║F M E║ Password ║F M E║ Group name ║F M E║─────────────────────────────────────────────────║F M E║ Full Name ║F M E║ Access level 1 ║F M E║─────────────────────────────────────────────────║F M E║ Store user profile ║F M E║─────────────────────────────────────────────────║F M E║ Delete user from group ║F M E╚═════════════════════════════════════════════════╝F M EUsers Files Reports Exit 10:36:08 amF M E╔═════════════════════════════════════════════╗F M E║ New file ║F M E║─────────────────────────────────────────────║F M E║ Group name ║F M E║─────────────────────────────────────────────║F M E║ File access privileges ║F M E║─────────────────────────────────────────────║F M E║ Field access privileges ║F M E║ Access level 1 ║F M E║ Establish field privileges ║F M E║─────────────────────────────────────────────║F M E║ Store file privileges ║F M E║─────────────────────────────────────────────║F M E║ Cancel current entry ║F M E╚═════════════════════════════════════════════╝F M EUsers Files Reports Exit 10:37:05 amF M E╔═══════════════════╗F M E║ User Information ║F M E║───────────────────║F M E║ File Information ║F M E╚═══════════════════╝FA*A* M PAAEPage 72 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E┌──────────────────────┐F P E│ Locking Techniques │F P E└──────────────────────┘F P E┌─────────────────────┐F P E│ Autolock Features │F P E└─────────────────────┘F P EAs mentioned above dBASE IV automatically appropriatelyF P Esignals the network operating system when file or record locksF P Eare needed. No additional programming is required.F P E┌────────────────────────────────┐F P E│ Manual Locking Consideration │F P E└────────────────────────────────┘F P EThe following commands may be placed in your programs toF P Eforce locks and unlocks in addition to or in lieu of theF P Eautomatic locking provided by dBASE:F P ELOCK() FLOCK() RLOCK() UNLOCK()F P E( To turn automatic locking off: .SET EXCLUSIVE OFF )F P E┌──────────────────┐F P E│ Screen Refresh │F P E└──────────────────┘F P EOnce a record has been locked by an editing command byF P Eone user it can only be viewed by another. If changes are madeF P Eby TOM, MARY must wait until TOM is through. When TOMF P Efinishes, Mary's screen will be updated to reflect Tom'sF P Echanges. By using the CONVERT utility the database files willF P Ehave an additional field added which will hold informationF P Eabout the last changes made to a given record. By using theF P ELKSYS() function the time, date and user involved in the lastF P Echange can be obtained.F P E┌──────────────────────────┐F P E│ Transaction Processing │F P E└──────────────────────────┘F P EAssume that 20 data entry operators have been makingF P Echanges to your database system for seven hours. SuddenlyF P Ethere is a power outage and your UPS fails. At what point doF P Estart the data entry work again? By using the Begin and EndF P ETransaction structure you can rollback all transactions to theF P Ebeginning a start fresh.FA*A* A$A$ P E(c) Interco International Page 73PEAAF P EThe following example program shows the use ofF P Etransaction processing and LKSYS():F P ME* TRANPROC.PRGF M E* Example of Transaction ProcessingF M E*F M E* Also: Procedure, On Error, LKSYS(), Set ReprocessF M ESET REPROCESS TO 10 && Try network locks 10 times before errorF M EON ERROR DO errproc && Procedure errproc handles ROLLBACKF M Efileok=.T.F M EUSE empF M EIF fileokF M EBEGIN TRANSACTION && Begin transaction loggingF M EREPLACE ALL lname WITH 'BRUCE' FOR lname = 'Bruce' && ERROR IF LOCKEDF M ELIST LNAMEF M EWAITF M EEND TRANSACTION && End transaction logging and updateF M ELIST LNAMEF M EENDIFF M EON ERROR && Reset error handlingF M ERETURNF M EPROCEDURE ERRPROCF M EMANS='N'F M ECLEARF M EDO CASEF M ECASE ERROR() = 108 && File lockedF M Eotheruser=IIF(LEN(LKSYS(2))=0,'another',LKSYS(2)) && if no user nameF M EWAIT 'File is locked by '+TRIM(otheruser)+'. Press any key.'F M Efileok=.F.F M ERETURNF M ECASE ERROR() = 109 && Record lockedF M Eotheruser=IIF(LEN(LKSYS(2))=0,'another',LKSYS(2)) && if no user nameF M EWAIT 'Record is locked by '+TRIM(otheruser)+'. Press any key.'F M EOTHERWISE && Any other errorF M E@ 1,0 SAY MESSAGE()+' '+STR(ERROR(),4)F M EENDCASEF M E@ 2,0 SAY 'DO YOU WISH TO RETRY? ' GET MANS FUNCTION '!'F M EREADF M EIF MANS='Y' && RetryF M ECLEARF M ERETRYF M EELSE && RollbackF M ECLEARF M E@ 0,0 SAY 'ROLLING BACK YOUR CURRENT TRANSACTIONS...'F M EROLLBACKF M EENDIFF M ERETURNF M E* EOF: TRANPROC.PRGFA"A" M PAAEPage 74 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E┌──────────────────────────────┐F P E│ DATA TRANSFER TECHNIQUES │F P E└──────────────────────────────┘F P ETransferring data between dBase IV and other programs isF P Eone of the most important aspects of database usage. The ruleF P Eof thumb is: If the data can be created in ASCII format youF P Ecan transfer it. Additionally dBase can handle other fileF P Etypes directly.F P E┌───────────────────────────────┐F P E│ Concepts of COPY and APPEND │F P E└───────────────────────────────┘F P ME┌────────────────────────────────────────────────────┐F M E╓─┤ HELP: COPY ├─╖F M E║ └────────────────────────────────────────────────────┘ ║F M E║ COPY TO <filename>[[TYPE] <filetype>] ║F M E║ [FIELDS <field list>] [<scope>] [FOR <condition>] ║F M E║ [WHILE <condition>] ║F M E║ ║F M E║ ║F M E║ Duplicates all or part of an active database file, ║F M E║ creating a new file. ║F M E║ ║F M E║ <filetype> = DBASEII/DELIMITED/DIF/FW2/RPD/SDF/ ║F M E║ SYLK/WKS ║F M E║ ║F M E║ Ex: COPY TO Calif FIELDS Lastname FOR State = 'CA' ║F M E║ ║F M E╟────────────────────────────────────────────────────────╢F M E║ CONTENTS RELATED TOPICS PRINT ║F M E╙────────────────────────────────────────────────────────╜F M E┌────────────────────────────────────────────────────┐F M E╓─┤ HELP: APPEND FROM ├─╖F M E║ └────────────────────────────────────────────────────┘ ║F M E║ APPEND FROM <filename>/?/ARRAY <array name> ║F M E║ [[TYPE] <file type>] [FOR <condition>] ║F M E║ ║F M E║ Adds one or more records from the specified source ║F M E║ file to the end of the active database file. Data ║F M E║ in matching field names in the source and active ║F M E║ database file will be copied. ║F M E║ ║F M E║ The contents of each row in the named array may ║F M E║ become a new record in the databse file. ║F M E║ ║F M E║ ║F M E║ ║F M E╟────────────────────────────────────────────────────────╢F M E║ CONTENTS RELATED TOPICS PRINT ║F M E╙────────────────────────────────────────────────────────╜FA"A" M PAAE(c) Interco International Page 75 PEAAF P E┌───────────────┐F P E│ To and From │F P E└───────────────┘F P ELotus 123, Word Processors, Mainframes and Minicomputers,F P EASCII, DIF and SYLKF P MECatalog Tools Exit 7:39:46 amF M E╔══════════════════╗ASE IV CONTROL CENTERF M E║ Macros ║F M E║ Import ║:\DBSYS\CLASSES\BT4W\JOBCOST.CATF M E║ Export ║F M EData ║ ╔═════════════════════════════════════╗ Labels ApplicationsF M E╔═════════║ ║ RapidFile (.rpd) ║╦════════════╦════════════╗F M E║ <create║ ║ dBASE II (.db2) ║║ <create> ║ <create> ║F M E║─────────╚══║ Framework II (.fw2) ║║────────────║────────────║F M E║ CUSTOMER ║ Lotus 1-2-3 (.wks) ║║ CUSTOMER ║ CUSTEXAM ║F M E║ EMP ║ VisiCalc (.dif) ║║ EMP ║ CUSTOMER ║F M E║ EMPRATE ║ PFS:FILE ║║ ║ EMP ║F M E║ FUNCODE ║ SYLK-Multiplan ║║ ║ EMPRATE ║F M E║ JOB ║ Text fixed-length fields (.txt) ║║ ║ FUNCODE ║F M E║ TIME ║ Blank delimited (.txt) ║║ ║ JOB ║F M E║ ║ Character delimited {"} (.txt) ║║ ║ JOBMENU ║F M E║ ╚═════════════════════════════════════╝║ ║ TIME ║F M E╚════════════╩════════════╩════════════╩════════════╩════════════╩════════════╝F M EFile: New fileF M EDescription: Press ENTER on <create> to create a new fileF M ECatalog Tools Exit 7:40:52 amF M E╔══════════════════╗ASE IV CONTROL CENTERF M E║ Macros ║F M E║ Import ║:\DBSYS\CLASSES\BT4W\JOBCOST.CATF M E║ ╔═════════════════════════╗F M EData ║ ║ RapidFile (.rpd) ║ Reports Labels ApplicationsF M E╔═════════║ ║ dBASE II (.db2) ║════════════╦════════════╦════════════╗F M E║ <create║ ║ Framework II (.fw2) ║ <create> ║ <create> ║ <create> ║F M E║─────────╚══║ Lotus 1-2-3 (.wk1) ║────────────║────────────║────────────║F M E║ CUSTOMER ║ PFS:FILE ║ CUSTOMER ║ CUSTOMER ║ CUSTEXAM ║F M E║ EMP ╚═════════════════════════╝ EMP ║ EMP ║ CUSTOMER ║F M E║ EMPRATE ║ INVOICE ║ EMPRATE ║ EMPPHONE ║ ║ EMP ║F M E║ FUNCODE ║ JOBHRSRT ║ FUNCODE ║ EMPRATE ║ ║ EMPRATE ║F M E║ JOB ║ JOBSTAT ║ JOB ║ FUNCODE ║ ║ FUNCODE ║F M E║ TIME ║ TIMEEDIT ║ TIME ║ INVOICE ║ ║ JOB ║F M E║ ║ *MARK ║ ║ JOB ║ ║ JOBMENU ║F M E║ ║ *UNMARK ║ ║ JOBSTAT ║ ║ TIME ║F M E╚════════════╩════════════╩════════════╩════════════╩════════════╩════════════╝F M EFile: New fileF M EDescription: Press ENTER on <create> to create a new fileFAA M PAAEPage 76 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P MELayout Organize Append Go To Exit 7:42:33 aF M E╔═════════════════════════════════════╗F M E┌─────┬────────────┬║ Enter records from keyboard ║es remaining: 3844F M E│ Num │ Field Name │║ Append records from dBASE file ║F M E╞═════╪════════════╪║ Copy records from non-dBASE file ║F M E│ 1 │ CUSTCODE │╚═╔══════════════════════════════════════╗F M E│ 2 │ CUSTNAME │ C║ RapidFile (.rpd) ║F M E│ 3 │ ADDRESS │ C║ dBASE II (.db2) ║F M E│ 4 │ CITY │ C║ Framework II (.fw2) ║F M E│ 5 │ STATE │ C║ Lotus 1-2-3 (.wks) ║F M E│ 6 │ ZIP │ C║ VisiCalc (.dif) ║F M E│ 7 │ REMARKS │ M║ SYLK-Multiplan ║F M E│ 8 │ PHONE │ C║ Text fixed-length fields (.txt) ║F M E│ 9 │ CONTACT │ C║ Blank delimited (.txt) ║F M E│ │ │ ║ Character delimited {"} (.txt) ║F M E│ │ │ ╚══════════════════════════════════════╝FA*A* A)A) M PAAE(c) Interco International Page 77 PEAAF P E┌─────────────────────────────────────────────────────────┐F P E│ Appending from a Fixed-Length Text File (ASCII, SDF). │F P E└─────────────────────────────────────────────────────────┘F P E1. View ASCII file using text editor or TYPE command. IdentifyF P Efields. Count spaces for length. Assign field types.F P E2. In dBase create a data file using the fieldnames, lengthsF P Eand types from Step 1.F P E3. APPEND FROM the text file TYPE SDF.F P E4. EDIT the new records to verify that data was importedF P Eaccurately.F P E5. If the transfer is to be done on a regular basis, write aF P Eshort program to accomplish it.F P E┌──────────────────────────────────────────────────────────┐F P E│ dBASE DIRECT - Direct Manipulation of Minicomputer Data │F P E└──────────────────────────────────────────────────────────┘F P EOther companion products to dBase IV is Direct/36 andF P EDirect/38 which allow direct manipulation of IBM System 36/38F P Edata from programs written in dBase IV. There are additionalF P Eproducts planned for similar use with DEC and IBM mainframesF P Eand other minicomputer systems.FA*A* A(A( P EPage 78 (c) Interco InternationalPEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E┌───────────────────────────────────┐F P E│ SQL - STRUCTURED QUERY LANGUAGE │F P E└───────────────────────────────────┘F P EdBase IV includes a Structured Query Language based onF P Ethe IBM DATABASE 2 and SQL/DS commands for mini and mainframeF P Ecomputers. This compatibility and the ability to interfaceF P Ewith dBase data files and programs provides a foundation forF P Edatabase design that is not limited to one language or oneF P Ekind of hardware.F P E┌───────────────────────────────────────┐F P E│ Definitions - A Comparison of Terms │F P E└───────────────────────────────────────┘F P ESQL dBASEF P EDatabase Group of related filesF P ETable Database fileF P ERow RecordF P EColumn FieldF P E┌──────────────┐F P E│ Data Types │F P E└──────────────┘F P ESMALLINTF P EWhole numbers from -99999 to 999999F P EINTEGERF P EPositive whole numbers up to 11 digitsF P ENegative whole numbers up to 10 digitsF P EFLOAT (x,y)F P ENumbers from 0.1e-307 to 0.9e+308, expressed inF P Eexponential notation:F P E(x) = the total number of digitsF P E(y) = places right of the decimal pointF P EDECIMAL (x,y) NUMERIC (x,y)F P EBoth DECIMAL and NUMERIC hold numbers:F P E(x) = the total number of digitsF P E(y) = places to the right of the decimal pointF P ECHAR (n)F P EHolds a string (n) characters longF P ELOGICALF P EHolds only True/False values.F P EDATEF P EDATE valuesFA'A' P E(c) Interco International Page 79PEAAF P E┌──────────────┐F P E│ SQL Commands │F P E└──────────────┘F P EALL OptionF P EALTER TABLEF P EASC and DESC OptionsF P EAVG FunctionF P ECLOSEF P ECOUNT FunctionF P ECREATE CommandsF P ECREATE DATABASEF P ECREATE INDEXF P ECREATE SYNONYMF P ECREATE TABLEF P ECREATE VIEWF P EDBCHECKF P EDBDEFINEF P EDECLARE CURSORF P EDELETEF P EDELETE WHERE CURRENT OFF P EDISTINCT OptionF P EDROP CommandsF P EDROP DATABASEF P EDROP INDEXF P EDROP SYNONYMF P EDROP TABLEF P EDROP VIEWF P EFETCHF P EGRANTF P EINSERTF P ELOADF P EMAX and MIN FunctionsF P EOPENF P EREVOKEF P EROLLBACKF P ERUNSTATSF P ESELECT CommandF P ESELECT Clause in SELECTF P EFOR UPDATE OF Clause in SELECTF P EFROM Clause in SELECTF P EGROUP BY Clause in SELECTF P EHAVING Clause in SELECTF P EINTO Clause in SELECTF P EORDER BY Clause in SELECTF P ESAVE TO TEMP Clause in SELECTFA*A* A!A! P EPage 80 (c) Interco InternationalPEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P EWHERE Clause in SELECTF P EWHERE - AND and OR to link conditionsF P EWHERE - ANY and ALL with subselectsF P EWHERE - BETWEEN conditionF P EWHERE - EXISTS conditionF P EWHERE - IN conditionsF P EWHERE - Joining TablesF P EWHERE - LIKE conditionF P EWHERE - Nesting SELECTsF P EWHERE - NOT to reverse conditionsF P EWHERE - Comparison conditionsF P EAND and OR in WHERE ClauseF P EANY and ALL in WHERE ClauseF P EBETWEEN in WHERE ClauseF P EEXISTS in WHERE ClauseF P EIN in WHERE ClauseF P ELIKE in WHERE ClauseF P ENOT in WHERE ClauseF P ESET SQL OFFF P ESHOW DATABASEF P ESTART DATABASEF P ESTOP DATABASEF P ESUM FunctionF P EUNION OperationF P EUNIQUE OptionF P EUNLOADF P EUPDATEF P EUPDATE WHERE CURRENT OFF P EUSER KeywordFA*A* P E(c) Interco International Page 81PEAAF P EIn this section we will show the accessing of dBase IVF P Edata files with SQL commands.F P E┌────────────────────────────────┐F P E│ SQL and dBASE IV Programming │F P E└────────────────────────────────┘F P EThe following program SQLDEMO.PRS demonstrates the basicsF P Eof data retrieval, selection, ordering and multifile joins.F P E* SQLDEMO.PRSF P E*F P ESTART DATABASE samples;F P ECLEARF P E? "Simple Retrieval:"F P ESELECT fname, lnameF P EFROM emp;F P EWAITF P ECLEARF P E? "Retrieval with Selection and Order:"F P ESELECT lname,addressF P EFROM empF P EWHERE lname > "M"F P EORDER BY lname;F P EWAITF P ECLEARF P E? "Joining of EMP and EMPRATE then Retrieval:"F P ESELECT fname,lname, emprate.rateF P EFROM emp,emprateF P EWHERE emp.empid=emprate.empidF P EORDER BY lname;F P EWAITF P ECLEARFA*A* A(A( P EPage 82 (c) Interco InternationalPEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P MESimple Retrieval:F M EFNAME LNAMEF M ECharles BruceF M ELisa MarieF M ESally MiddletonF M EKael CognacF M EJean LacrouxF M EGeorge TroutmanF M EKevin BarryF M EChristopher BryanF M EAllison JonahF M EHolly KathleenovitchF M EJeff BonnackerF M EStuart BrooksF M EJoseph RandallF M ERobert BruceF M EBonnie ConnorsF M EBlaise LacrouxF M ELeigh ZoellnerF M ENell RidleyF M ERetrieval with Selection and Order:F M ELNAME ADDRESSF M ERandall 234 Destin WayF M ERidley 4785 Elm StreetF M ETroutman 1212 Easy StreetF M EZoellner 123 Northwest PassageF M EJoining of EMP and EMPRATE then Retrieval:F M EEMP->FNAME EMP->LNAME EMPRATE->RATEF M EKevin Barry 60.00F M EJeff Bonnacker 40.00F M EStuart Brooks 50.00F M ERobert Bruce 65.00F M ECharles Bruce 55.00F M EChristopher Bryan 25.00F M EKael Cognac 35.00F M EBonnie Connors 60.00F M EAllison Jonah 40.00F M EHolly Kathleenovitch 50.00F M EJean Lacroux 50.00F M EBlaise Lacroux 35.00F M ELisa Marie 25.00F M ESally Middleton 50.00F M EJoseph Randall 50.00F M ENell Ridley 45.00F M EGeorge Troutman 50.00F M ELeigh Zoellner 50.00FAA M PAAE(c) Interco International Page 83 PEAAF P E┌────────────────────────────────────────────────┐F P E│ IMPORTANT NEW dBASE IV COMMANDS AND FUNCTIONS │F P E└────────────────────────────────────────────────┘F P EAs you have seen dBase IV commands and functions can beF P Eembedded into the application generator at numerous positions.F P EThe following new commands can be used there as well as inF P Ehand written programs using the MODIFY COMMAND Editor.F P E┌────────────────┐F P E│ New Commands │F P E└────────────────┘F P E??? [<expC>]F P E@ <row1>,<col1> FILL TO <row2>,<col2>F P E[COLOR <color attribute>]F P EACTIVATE WINDOW <window name list>/ALLF P EAPPEND MEMO <memo field name> FROM <filename>F P E[OVERWRITE]F P ECALCULATE [<scope>] <option list>F P E[FOR <condition>] [WHILE <condition>]F P E[TO <memvar list>/TO ARRAY <array name>]F P ECOMPILE <filename exp> [RUNTIME]F P ECONVERT [TO <expN>]F P ECOPY INDEXES <.ndx file list>F P E[TO <.mdx filename>]F P ECOPY TAG <tag name> [OF <.mdx filename>]F P ETO <.ndx filename>F P ECOPY TO ARRAY <array name> [FIELDS <fields list>]F P E[<scope>] [FOR <condition>] [WHILE <condition>]F P ECREATE/MODIFY APPLICATION <filename>/?F P EDBLINK <input filename>/[L]F P EDEBUG <filename>/<procedure name>F P E[WITH <parameter list>]F P EDECLARE <array name 1> [{<number of rows>,}F P E{<number of columns>}] {,<array name 2>F P E[{<number of columns>}]...}FA*A* P EPage 84 (c) Interco InternationalPEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P EDEFINE WINDOW <window name> FROM <row1>,<col1>F P ETO <row2>,<col2> [DOUBLE/PANEL/NONE/<borderF P Edefinition string>] [COLOR [<standard>]F P E[,<enhanced>] [,<frame>]]F P EDIR/DIRECTORY [[ON] <drive>:] [[LIKE] [<path>]F P E<skeleton>]F P EDISPLAY USERSF P EEXPORT TO <filename> [TYPE] PFS/FW2/RPD/dBASEIIF P E[FIELDS <field list>] [<scope>]F P E[FOR <condition>] [WHILE <condition>]F P EFUNCTION <procedure name>F P EIMPORT FROM <filename>F P E[[TYPE] PFS/FW2/RPD/WK1/dBASEII]F P ELOGOUTF P EMOVE WINDOW <window name> TO <row>,<column>/BYF P E<delta row>,<delta col>F P EON PAD <pad name> OF <menu name> [ACTIVATE POPUPF P E<popup name>]F P EON PAGE [AT LINE <expN> <command>]F P EON READERROR [<command>]F P EON SELECTION PAD <pad name> OF <menu name>F P E[<command>]F P EON SELECTION POPUP <popup name>/ALL [<command>]F P EPLAY MACRO <macro name>F P EPRINTF P E<commands>F P EENDPRINT JOBF P EPROTECTF P ERESET [IN <alias>]F P ERESTORE MACROS FROM <macro file>F P EROLLBACK [<database filename>]F P ESCAN [<scope>] [FOR <condition>]F P E[WHILE <condition>][<commands>]F P E[LOOP]F P E[EXIT]F P EENDSCANF P ESHOW MENU <menu name> [PAD <pad name>]FA*A* P E(c) Interco International Page 85PEAAF P E┌────────────────────┐F P E│ New Set Commands │F P E└────────────────────┘F P ESET AUTOSAVE on/OFFF P ESET BLOCKSIZE TO <expN>F P ESET BORDER TO [SINGLE/DOUBLE/PANEL/NONE/F P E<border definition string>]F P ESET CLOCK TO [<row>,<column>]F P ESET CLOCK on/OFFF P ESET COLOR ON/OFFF P ESET COLOR OF NORMAL/MESSAGES/TITLES/BOX/F P EHIGHLIGHT/INFORMATION/FIELDS TO [< color attribute>]F P ESET CURRENCY LEFT/rightF P ESET CURRENCY TO <expC>F P ESET DATE [TO] AMERICAN/ansi/british/french/german/F P Eitalian/japan/usa/mdy/dmy/ymdF P ESET DEVELOPMENT ON/offF P ESET DEVICE TO SCREEN/printer/file <filename>F P ESET DISPLAY TO MONO/COLOR/EGA25/EGA43/MONO43F P ESET ENCRYPTION on/OFFF P ESET FUNCTION <expN> TO <expC>F P ESET FULLPATH on/OFFF P ESET HOURS TO [12/24]F P ESET INSTRUCT ON/offF P ESET LOCK ON/offF P ESET MARK TO [<expC>]F P ESET NEAR on/OFFF P ESET ORDER TO [<expN>]/[TAG <mdxtag> [OF <mdxname>]]F P ESET PAUSE on/OFF ** SQLF P ESET POINT TO [<expC>]F P ESET PRECISION TO [<expN>] ** 16FA'A' P EPage 86 (c) Interco InternationalPEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P ESET PRINTER TO <DOS device>F P ESET PRINTER TO \\<computer name>\<printer name>=F P E<destination>F P ESET PRINTER TO \\SPOOLERF P ESET PRINTER TO \\CAPTUREF P ESET PRINTER TO FILE <filename>F P ESET REFRESH TO <expN>F P ESET REPROCESS TO <expN>F P ESET SEPARATOR TO [<expC>]F P ESET SKIP TO [<alias> [,<alias>]...]F P ESET SPACE ON/offF P ESET SQL on/OFFF P ESET TRAP on/OFFF P ESET WINDOW OF MEMO TO <window name>FA*A* P E(c) Interco International Page 87PEAAF P E┌─────────────────┐F P E│ New Functions │F P E└─────────────────┘F P EABS(<expN>)F P EACOS(<expN>)F P EASIN(<expN>)F P EATAN(<expN>)F P EATN2(<expN1>, <expN2>)F P EBOF([<alias name>])F P EBAR()F P ECALCULATE FUNCTIONSF P EAVG(<expN>)F P ECNT()F P EMAX(<exp>)F P EMIN(<exp>)F P ENPV(<rate>,<flows>,<initial>)F P ESTD(<expN>)F P ESUM(<expN>)F P EVAR(<expN>)F P ECALL(<expC>,<expC>/<memvar>)F P ECEILING(<expN>)F P ECHANGE()F P ECOMPLETED()F P ECOS(<expN>)F P EDIFFERENCE(<expC>, <expC>)F P EDMY(<expD>)F P EDTOR(<expN>)F P EEOF([<alias name>])F P EDTOS(<expD>)F P EEXP(<expN>)F P EFIELD(<expC>[,<alias>])F P EFLOAT(<expN>)FA'A' P EPage 88 (c) Interco InternationalPEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P EFLOOR(<expN>)F P EFOUND([<alias>])F P EFV(<payment>,<rate>,<periods>)F P EISMARKED([<alias>])F P EKEY([<mdxfile>,] <expN> [,<alias>])F P ELASTKEY()F P ELIKE(<pattern>, <Expc>)F P ELINENO()F P ELKSYS(n)F P ELOG10(<expN>)F P ELOOKUP(<return field>,<look-for exp>,F P E<look in field>)F P EMDX(<expN> [,<alias>])F P EMDY(<expD>)F P EMEMLINES(memo field name)F P EMEMORY([0])F P EMENU()F P EMLINE(<memo field name>,<expN>)F P ENETWORK()F P EORDER([<alias>])F P EPAD()F P EPAYMENT(<principal>,<rate>,<periods>)F P EPI()F P EPOPUP()F P EPRINTSTATUS()F P EPROGRAM()F P EPROMPT()F P EPV(<payment>,<rate>,<periods>)FA'A' P E(c) Interco International Page 89PEAAF P ERAND([<expN>])F P EROLLBACK()F P ERTOD(<expN>)F P ESEEK(<expC> [,<alias>])F P ESET(<expC>)F P ESIGN(<expN>)F P ESIN(<expN>)F P ESOUNDEX(<expC>)F P ETAG([<MDXfile>,] <expN> [,<alias>])F P ETAN(<expN>)F P ETIME()F P EUSER()F P EVARREAD()FA*A* A&A& P EPage 90 (c) Interco InternationalPEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E┌────────────────────────┐F P E│ New System Variables │F P E└────────────────────────┘F P EMemvar Type RangeF P E_alignment char "LEFT", "RIGHT", "CENTER"F P E_box logic TRUE or FALSEF P E_indent num between 0 and 254F P E_lmargin num between 0 and 254F P E_padvance char "FORMFEED", "LINEFEEDS"F P E_pageno num between 1 and 32767F P E_pbpage num between 1 and 32767F P E_pcolno num between 0 and 255F P E_pcopies num between 1 and 32767F P E_pdriver char a valid DOS file nameF P E_pecode char string of less than 255 char.F P E_peject char "BEFORE","AFTER","BOTH","NONE"F P E_pepage num between 1 and 32767F P E_pform char a valid DOS filenameF P E_plength num between 1 and 32767F P E_plineno num between 0 and (_plength-1)F P E_ploffset num between 0 and 254F P E_ppitch char "PICA", "ELITE", "CONDENSED",F P E"DEFAULT"F P E_pquality logic TRUE or FALSEF P E_pscode char string less than 255 charF P E_pspacing num integers 1, 2, or 3F P E_pwait logic TRUE or FALSEF P E_rmargin num between 1 and 255F P E_tabs char string of numbers separatedF P Eby commas in ascending orderF P E_wrap logic TRUE or FALSEFA*A* P E(c) Interco International Page 91PEAAF P E┌─────────────────────────────────┐F P E│ CONSIDERATIONS FOR THE FUTURE │F P E└─────────────────────────────────┘F P E┌────────────────────────────────────┐F P E│ Operating Systems: DOS 4.0 OS/2 │F P E└────────────────────────────────────┘F P EAs released dBase IV can be used with MSDOS and OS/2 inF P Ethe protected mode. Ashton-Tate has announced its commitmentF P Eto OS/2 and is expected to release a version of dBase IV thatF P Ewill utilize the virtues of this technology. Be aware howeverF P Ethat moving to OS/2 will require sizeable hardware upgradeF P Ecosts. You should weigh heavily the costs and benefits beforeF P Emaking this decision.F P E┌─────────────────────────────────┐F P E│ Local Area Network Technology │F P E└─────────────────────────────────┘F P EdBase IV provides transparent support for all major localF P Earea network operating systems. All database systemsF P Eincluding dBase IV can experience degradation of performanceF P Eas the number of records and number of users increase. If youF P Eexperience unsatisfactory performance as these factorsF P Eincrease, you should look into the possibilities of using asF P Efaster LAN server (80386 or higher) or the dedicated serverF P Etechnology mentioned below. As of early 1989 this technologyF P Eis a relatively expensive option. As time goes on andF P Ecompetition in this field continues you can expect largeF P Ereductions in cost.F P E┌─────────────────────┐F P E│ Server Technology │F P E└─────────────────────┘F P EDatabase server technology is designed to reduce dataF P Eaccess and processing time when large numbers of users areF P Eaccessing large amounts of data. In a single user databaseF P Esystem the CPU accesses the disk bringing in as much data asF P Ememory allows then processes the required activity. IfF P Enecessary this process continues until all of the data isF P Eprocessed. With current LAN technology the LAN server accessesF P Ethe data from the disk and sends it to the users CPU where theF P Eprocessing is done. Both of these methods require that theF P Eentire data set be sent to the users CPU even though only aF P Esmall portion of it may have been requested. The databaseF P Eserver concept is to add an additional CPU that is dedicatedF P Eto processing requests within its own memory and sending theF P Eresulting data to the user's CPU. This would increase accessF P Eand processing time dramatically.FA&A& P EPage 92 (c) Interco InternationalPEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P EAshton-Tate will soon provide a database server that isF P Edesigned to work transparently with your dBase IV systemsF P Eincluding SQL. The cost is expected to be relatively high upF P Eto $15,000 US for software and hardware. However when comparedF P Eto a minicomputer with similar performance, the cost may beF P Ereasonable. It is recommended that a cost-benefit analysis beF P Ecompleted which compares the improvement in processing timeF P Ewith the cost of the new equipment and software. With theF P Eprospect of Intel's 80486 chip on the horizon there will beF P Eimprovement in LAN server speed which may alleviate the needF P Efor the database server in some instances.FA*A* A'A' P E(c) Interco International Page 93PEAAF P E┌────────────────┐F P E│ COURSE SUMMARY │F P E└────────────────┘F P EThis completes the presentation of ADVANCED DATABASEF P EDESIGN WITH DBASE IV. Its purpose was to further educateF P Esystems designers in the design and implementation of theF P Eadvanced features of dBase IV including working with multipleF P Efiles, SQL, advanced uses of the Application Generator andF P Eexplanation of the new commands and functions available forF P Euse within programs. A student should have a goodF P Eunderstanding of the worksheet concept from this course and beF P Eable to produce working single file systems before undertakingF P Ethe advanced course.FA*A* A'A' P EPage 94 (c) Interco InternationalPEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P ECOURSE EXERCISESF P E▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒F P EYour instructor may select from the exercises below orF P Emay choose other examples that will give you practice inF P Ethe use of the features of dBase IV. You should use theF P Eblank worksheets that are found at the end of this manualF P Eto design the system.F P E▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒F P EEXERCISE 1F P ECreate a Personal Checkbook System using the ItemsF P EWorksheet below. For Checks and Deposits design andF P Ecreate a data file, screen form and a report. Enter 5F P Edeposits and 10 checks and produce the reports.F P MEWIWFEWTWFEWEWFEWMWFEWSWF EWWWFEWOWFEWRWFEWKWFEWSWFEWHWFEWEWFEWEWFEWTWF M EPART OF ___Chekbook___ SYSTEMF M EPAGE ___1__ of ___1__ DATE _____________F M EITEM DESCRIPTION SOURCE FIELD NAMEF M EINPUT/REPORT NAMEF M EDate of Transaction_________________ Check/Deposit_______ __________F M EType of Transaction_(_C or D )______ Check/Deposit_______ __________F M EName of Payee or Source of Deposit__ Check/Deposit_______ __________F M EAmount of Check or Deposit__________ Check/Deposit_______ __________F M EDescription ________________________ Check/Deposit_______ __________FA&A& M PAAE(c) Interco International Page 95 PEAAF P EEXERCISE 2F P ECreate an Office Inventory System using the ItemsF P EWorksheet below. Design and create a data file, screenF P Eform and a report for each group. Enter 10 items andF P Eproduce the report.F P MEWIWFEWTWFEWEWFEWMWFEWSWF EWWWFEWOWFEWRWFEWKWFEWSWFEWHWFEWEWFEWEWFEWTWF M EPART OF ___Inventor___ SYSTEMF M EPAGE ___1__ of ___1__ DATE _____________F M EITEM DESCRIPTION SOURCE FIELD NAMEF M EINPUT/REPORT NAMEF M EName of Item________________________ ____________________ __________F M ESerial Number_______________________ ____________________ __________F M EModel Number________________________ ____________________ __________F M EQuantity ___________________________ ____________________ __________F M EDepartment _________________________ ____________________ __________F M EDepartment ________________________ ____________________ __________F M EManager _______________________ ____________________ __________F M ELocation ________________________ ____________________ __________F M EPhone ___________________________ ____________________ __________FA*A* A&A& M PAAEPage 96 (c) Interco International PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P EdBASE IV FUNCTION KEYSF P EF1 HELPF P EF2 DATAF P EF3 PREVIOUSF P EF4 NEXTF P EF5 FIELDF P EF6 EXTEND SELECTF P EF7 MOVEF P EF8 COPYF P EF9 ZOOMF P EF10 MENUSF P ESHIFT F1 PICKF P ESHIFT F2 DESIGNF P ESHIFT F3 FIND PREVIOUSF P ESHIFT F4 FIND NEXTF P ESHIFT F5 FINDF P ESHIFT F6 REPLACEF P ESHIFT F7 SIZEF P ESHIFT F8 DITTOF P ESHIFT F9 QUICK REPORTF P ESHIFT F10 MACROSFA%A% P E(c) Interco International Page 97PEAAF P EdBASE IV FILE EXTENSIONSF P EFile extensions are the three letters following theF P Eperiod in the file name. dBASE assigns the followingF P Eextensions:F P E.BAR Horizontal Bar MenuF P E.BCH Batch FileF P E.BIN Binary FileF P E.CAT Catalog FileF P E.COD Template Source FileF P E.CPT Encrypted Memo FileF P E.CRP Password InformationF P EFileF P E.DBF Database FileF P E.DBT Memo Variable FileF P E.DOC Documentation FileF P E.KEY Macro Key FileF P E.LOG Transaction Log FileF P E.MEM Memory Variable FileF P E.MDX Index FileF P E.NDX Index File dBase IIIF P E.POP Pop-up MenuF P E.PR2 Printer Definition FileF P E.PRF Print Form FileF P E.PRT Printer Output FileF P E.VUE View File dBase IIIF P E.WIN Window FileF P EDESIGN CODE COMPILEDF P E---- ---- ----F P E.APP .PRG .DBO Application FileF P E.PRG .DBO Program FileF P E.PRS .DBO SQL Program FileF P E.FRM .FRG .FRO Report Form FileF P E.LBL .LBG .LBO Report Form FileF P E.QBE .QBO Query FileF P E.SCR .FMT .FMO Screen FileF P E.UPD .UPO Update FileFA)A) P EPage 98 (c) Interco InternationalPEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P EJOB COST SYSTEM FILE STRUCTURESF P EStructure for database: D:\DBSYS\CLASSES\BT4\CUSTOMER.DBFF P ENumber of data records: 6F P EDate of last update : 10/06/88F P EField Field Name Type Width Dec IndexF P E1 CUSTCODE Character 10 YF P E2 CUSTNAME Character 25 YF P E3 ADDRESS Character 25 NF P E4 CITY Character 25 NF P E5 STATE Character 2 NF P E6 ZIP Character 5 NF P E7 REMARKS Memo 10 NF P E8 PHONE Character 14 NF P E9 CONTACT Character 40 NF P E** Total ** 157F P EStructure for database: D:\DBSYS\CLASSES\BT4\EMP.DBFF P ENumber of data records: 18F P EDate of last update : 10/13/88F P EField Field Name Type Width Dec IndexF P E1 EMPID Character 5 YF P E2 DEPT Character 4 YF P E3 LNAME Character 25 YF P E4 FNAME Character 20 NF P E5 ADDRESS Character 25 NF P E6 CITY Character 25 NF P E7 STATE Character 2 NF P E8 ZIP Character 10 YF P E9 EMPDATE Date 8 YF P E10 ACTIVE Logical 1 NF P E11 COMMENTS Memo 10 NF P E12 SKILLS Character 25 NF P E13 PHONE Character 14 NF P E** Total ** 175F P EStructure for database: D:\DBSYS\CLASSES\BT4\EMPRATE.DBFF P ENumber of data records: 18F P EDate of last update : 10/06/88F P EField Field Name Type Width Dec IndexF P E1 EMPID Character 5 YF P E2 RATE Numeric 6 2 NF P E3 RATEDATE Date 8 NF P E** Total ** 20FA*A* A A P E(c) Interco International Page 99PEAAF P EStructure for database: D:\DBSYS\CLASSES\BT4\FUNCODE.DBFF P ENumber of data records: 5F P EDate of last update : 10/14/88F P EField Field Name Type Width Dec IndexF P E1 FUNCODE Character 6 YF P E2 FUNDESC Character 35 YF P E** Total ** 42F P EStructure for database: D:\DBSYS\CLASSES\BT4\JOB.DBFF P ENumber of data records: 7F P EDate of last update : 10/11/88F P EField Field Name Type Width Dec IndexF P E1 JOBID Character 5 YF P E2 JOBDESC Character 50 YF P E3 CUSTCODE Character 10 YF P E4 COMPLETED Logical 1 NF P E5 INVOICED Logical 1 NF P E6 BIDPRICE Numeric 10 2 NF P E7 STARTDATE Date 8 YF P E8 COMPDATE Date 8 NF P E9 PAID Logical 1 NF P E** Total ** 95F P EStructure for database: D:\DBSYS\CLASSES\BT4\TIME.DBFF P ENumber of data records: 80F P EDate of last update : 10/14/88F P EField Field Name Type Width Dec IndexF P E1 DATE Date 8 NF P E2 EMPID Character 5 YF P E3 JOBID Character 5 YF P E4 HOURS Numeric 6 2 NF P E5 FUNCODE Character 6 YF P E** Total ** 31FA*A* A$A$ P EPage 100 (c) Interco InternationalPEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒F P EWIWFEWTWFEWEWFEWMWFEWSWF EWWWFEWOWFEWRWFEWKWFEWSWFEWHWFEWEWFEWEWFEWTWF P EPART OF _____________ SYSTEMF P EPAGE ______ of ______ DATE ______________F P EITEM DESCRIPTION SOURCE FIELD NAMEF P EINPUT/REPORT NAMEF P E____________________________________ ____________________ __________F P E____________________________________ ____________________ __________F P E____________________________________ ____________________ __________F P E____________________________________ ____________________ __________F P E____________________________________ ____________________ __________F P E____________________________________ ____________________ __________F P E____________________________________ ____________________ __________F P E____________________________________ ____________________ __________F P E____________________________________ ____________________ __________F P E____________________________________ ____________________ __________F P E____________________________________ ____________________ __________F P E____________________________________ ____________________ __________F P E____________________________________ ____________________ __________F P E____________________________________ ____________________ __________F P E____________________________________ ____________________ __________F P E____________________________________ ____________________ __________F P E____________________________________ ____________________ __________F P E____________________________________ ____________________ __________F P E____________________________________ ____________________ __________F P E____________________________________ ____________________ __________F P E____________________________________ ____________________ __________F P E____________________________________ ____________________ __________ PEAAF P E▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒F P EWDWFEWAWFEWTWFEWAWF EWFWFEWIWFEWLWFEWEWF EWWWFEWOWFEWRWFEWKWFEWSWFEWHWFEWEWFEWEWFEWTWF P EPART OF _____________ SYSTEMF P EPAGE ______ of ______ DATE ______________F P EFILE NAME (8 chars) : _____________F P EFILE DESCRIPTION : ___________________________________________F P E___________________________________________F P E___________________________________________F P E___________________________________________F P EORDERING (Indexes) : NAME (8 chars) KEY FIELDSF P E_____________ ___________________________F P E_____________ ___________________________F P E_____________ ___________________________F P E_____________ ___________________________F P EFIELD NAME DESCRIPTION TYPE WIDTH DEC VALIDATION INFOF P E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F P E___________ __________________ __ ____ __ ______________________F P E__________________ Pict________Func______F P E___________ __________________ __ ____ __ ______________________F P E__________________ Pict________Func______F P E___________ __________________ __ ____ __ ______________________F P E__________________ Pict________Func______F P E___________ __________________ __ ____ __ ______________________F P E__________________ Pict________Func______F P E___________ __________________ __ ____ __ ______________________F P E__________________ Pict________Func______F P E___________ __________________ __ ____ __ ______________________F P E__________________ Pict________Func______F P E___________ __________________ __ ____ __ ______________________F P E__________________ Pict________Func______F P E___________ __________________ __ ____ __ ______________________F P E__________________ Pict________Func______F P E___________ __________________ __ ____ __ ______________________F P E__________________ Pict________Func______F P E___________ __________________ __ ____ __ ______________________F P E__________________ Pict________Func______F P E___________ __________________ __ ____ __ ______________________F P E__________________ Pict________Func______F P E___________ __________________ __ ____ __ ______________________F P E__________________ Pict________Func______F P E___________ __________________ __ ____ __ ______________________F P E__________________ Pict________Func______F P E___________ __________________ __ ____ __ ______________________F P E__________________ Pict________Func______F P E___________ __________________ __ ____ __ ______________________F P E__________________ Pict________Func______ PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒F P EWQWFEWUWFEWEWFEWRWFEWYWF EWWWFEWOWFEWRWFEWKWFEWSWFEWHWFEWEWFEWEWFEWTWF P EPART OF _____________ SYSTEMF P EPAGE ______ of ______ DATE ______________F P EQUERY NAME (8 chars) :_____________F P EFILENAME: FIELDS:F P ELINK1 LINK2 LINK3 COND COND ORDER ORDERF P E┌────────────┬───────┬──────┬───────┬──────┬──────┬──────┬──────┐F P E│ │ │ │ │ │ │ │ │F P E╘════════════╪═══════╪══════╪═══════╪══════╪══════╪══════╪═══════F P E│ │ │ │ │ │ │ │F P E┌────────────┬───────┬──────┬───────┬──────┬──────┬──────┬──────┐F P E│ │ │ │ │ │ │ │ │F P E╘════════════╪═══════╪══════╪═══════╪══════╪══════╪══════╪═══════F P E│ │ │ │ │ │ │ │F P E┌────────────┬───────┬──────┬───────┬──────┬──────┬──────┬──────┐F P E│ │ │ │ │ │ │ │ │F P E╘════════════╪═══════╪══════╪═══════╪══════╪══════╪══════╪═══════F P E│ │ │ │ │ │ │ │F P E┌────────────┬───────┬──────┬───────┬──────┬──────┬──────┬──────┐F P E│ │ │ │ │ │ │ │ │F P E╘════════════╪═══════╪══════╪═══════╪══════╪══════╪══════╪═══════F P E│ │ │ │ │ │ │ │F P E┌────────────┬───────┬──────┬───────┬──────┬──────┬──────┬──────┐F P E│ │ │ │ │ │ │ │ │F P E╘════════════╪═══════╪══════╪═══════╪══════╪══════╪══════╪═══════F P E│ │ │ │ │ │ │ │F P E┌────────────┬───────┬──────┬───────┬──────┬──────┬──────┬──────┐F P E│Calculated │ │ │ │ │ │ │ │F P E╘════════════╪═══════╪══════╪═══════╪══════╪══════╪══════╪═══════F P E│ │ │ │ │ │ │ │F P E┌────────────┬───────┬──────┬───────┬──────┬──────┬──────┬──────┐F P E│Include │ │ │ │ │ │ │ │F P E╘════════════╪═══════╪══════╪═══════╪══════╪══════╪══════╪═══════F P E│ │ │ │ │ │ │ │F P E┌────────────┬───────┬──────┬───────┬──────┬──────┬──────┬──────┐F P E│Include │ │ │ │ │ │ │ │F P E╘════════════╪═══════╪══════╪═══════╪══════╪══════╪══════╪═══════F P E│ │ │ │ │ │ │ │ PEAAF P E▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒F P EWSWFEWCWFEWRWFEWEWFEWEWFEWNWF EWFWFEWOWFEWRWFEWMWF EWWWFEWOWFEWRWFEWKWFEWSWFEWHWFEWEWFEWEWFEWTWF P EPART OF _____________ SYSTEMF P EPAGE ______ of ______ DATE ______________F P ESCREEN NAME (8 chars) :_____________F P EDATA FILE OR QUERY NAME (8 chars) : _____________F P E╔════════════════════════════════════════════════════════════════╗F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E╚════════════════════════════════════════════════════════════════╝ PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒F P EWRWFEWEWFEWPWFEWOWFEWRWFEWTWF EWWWFEWOWFEWRWFEWKWFEWSWFEWHWFEWEWFEWEWFEWTWF P EPART OF _____________ SYSTEMF P EPAGE ______ of ______ DATE ______________F P EREPORT NAME (8 chars) :_____________F P EDATA FILE OR QUERY NAME (8 chars) : _____________F P E[····∙·· ·1····∙ ···2··· ∙····3· ··∙···· ····∙·· ·5····∙ ···6···∙····7F P EPage Header Band────────────────────────────────────────────────F P E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F P EReport Intro Band────────────────────────────────────────────────F P E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F P EGroup 1 Intro Band────────────────────────────────────────────────F P E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F P EDetail Band────────────────────────────────────────────────F P E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F P EGroup 1 SummaryBand────────────────────────────────────────────────F P E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F P EReport SummaryBand────────────────────────────────────────────────F P E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░F P EPage Footer Band────────────────────────────────────────────────F P E░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ PEAAF P E▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒F P EWLWFEWAWFEWBWFEWEWFEWLWF EWWWFEWOWFEWRWFEWKWFEWSWFEWHWFEWEWFEWEWFEWTWF P EPART OF _____________ SYSTEMF P EPAGE ______ of ______ DATE ______________F P ELABEL NAME (8 chars) :_____________F P EDATA FILE OR QUERY NAME (8 chars) : _____________F P ELABEL SIZE: _______________ NUMBER OF LABELS ACROSS _______F P ELABEL LAYOUT:F P E[····∙·· ·1····∙ ···2··· ∙····3· ··∙····4····∙·· ·5F P E╔════════════════════════════════════════════════╗F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E╚════════════════════════════════════════════════╝ PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P E▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒F P EWMWFEWEWFEWNWFEWUWF EWWWFEWOWFEWRWFEWKWFEWSWFEWHWFEWEWFEWEWFEWTWF P EPART OF _____________ SYSTEMF P EPAGE ______ of ______ DATE ______________F P EMENU NAME (8 chars) :_____________F P EDATA FILE OR QUERY NAME (8 chars) : _____________F P EORDER NAME (8 chars) : _____________F P EMENU LAYOUT:F P EBARF P E╔═══════════════════════════════════════════════╗F P E║ ║F P E╚═══════════════════════════════════════════════╝F P EPOPUPF P E╔═════════════════════════╗F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E║ ║F P E╚═════════════════════════╝F P EON MENU OPTION PERFORM (MENU, BATCH or DBASE PRG)F P E______________ _________________________________F P E_________________________________F P E______________ _________________________________F P E_________________________________F P E______________ _________________________________F P E_________________________________F P E______________ _________________________________F P E_________________________________F P E______________ _________________________________F P E_________________________________F P E______________ _________________________________F P E_________________________________F P E______________ _________________________________F P E_________________________________ PEAAPEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P EWIndexWF P EWAWF ECREATE 2F P Eaccess levels 71F ECUSTOMER MENU 42F P EAD_APND.COD 58FAA P EWDWF P EAd Hoc Inquiries 3F P EDATA TRANSFERF P EADD 42F P ETECHNIQUES 75F P EAdvanced tools 41F P EDATA VALIDATION 1F P EAPGEN 38F P EDATA VALIDATION 32F P EAPGEN SUMMARY 58F P EDatabase 79F P EAPP 60F P EDatabase serverF P EAPPEND 75F P Etechnology 92F P EAppending 78F P EDATE 79F P Eapplication generatorsF P EdBASE DIRECT 78F P E38F P EdBase hacker 41F P EASCII 75, 76, 78F P EdBASE II 76F P EAutolock Features 73F P EDBLINK 61F P EAutomatic CompilingF P EDBO 60F P E59F P EDBSETUP 70F P Eautomatic locking 73F P EDEBUG 66FAA P EWBWF EDebugger 63, 66F P EBands 19F EDECIMAL 79F P EBEGIN TRANSACTION 74F EDECISIONS 37F P Ebenefits from usingF EDEFINE 2F P Eadvanced tools 41F EDESIGN 2F P Ebenefits of usingF EDesign 59F P EAPGEN 38F EDEVELOPER'S EDITION 41F P EBlank delimited 76F Edevelopers edition 61F P EBody 19F EDIF 76F P EBUILD 61F EDirect/36 78F P EDirect/38 78FAA P EWCWF P Edistributed programsF P ECHANGE 42F P E59F P ECHAR 79F P EDocumentation 39F P ECharacter delimited 76FAA P EClipper 67F EWEWF P EColumn 79F EGrouping 19F P ECompiled 59F EEditor 63F P Ecompiled 41F EELEMENTS OF DATABASEF P ECONDITIONAL SELECTIONF EDESIGN 2F P E1F EEMPLOYEE PAY RATEF P ECONSIDERATIONS FOR THEF EREPORT 31F P EFUTURE 92F Eencrypt data files 71F P EControl Center 19F EEND TRANSACTION 74F P Econversion of dBaseF EEXE 61F P EIII programs 63F Eexecution speed 59F P ECONVERT 73F EExperiencedF P ECOPY 75F Eprogrammers 58F P ECOST 37F EExport 76F P ECOURSE EXERCISES 95 PEAAF P EWFWF EMAINTENANCE 37F P EFILE EXTENSIONS 98F Emanagement 38, 61F P EFILE STRUCTURES 99F EManual Locking 73F P EFixed-Length 78F Ememo fields 63F P Efixed-length fields 76F EMenus 42F P EFLOAT 79F EMinicomputers 76F P EFMO 60F EModifications 38F P EFMT 60F EMODIFY 2F P EFooter 20F EMODIFY COMMAND 63F P EFoxbase 67F EMULTIPLE FILE LINKSF P EFramework 76F E11F P EFRG 60F EMULTIPLE FILE REPORTF P EFRM 60F ECREATION 19F P EFRO 60F EMULTIPLE FILES 1F P EFUNCTION KEYS 97F EMULTIUSER 70FAA P EWGWF EWNWFAA P EGrouping 19F Enetwork operatingF P Esystem 73FAA P EWHWF P ENew Commands 84F P EHeader 19F P ENEW dBASE IV COMMANDSFAA P EWIWF EAND FUNCTIONS 84F P EIBM DATABASE 2 andF ENew Functions 88F P ESQL/DS 79F ENew Set Commands 86F P EIBM System 36/38 78F ENew System VariablesF P EImport 76F E91F P EIMPORTANT NOTE 33F ENUMERIC 79F P Eindex 19FAA P EWOWF P EInstallation 70F P Eobject file 59F P EINTEGER 79F P Eobjective of thisF P EINVOICE.qbe 21F P Ecourse 1F P EINVOICE REPORT 22F P EOperating Systems: DOSFAA P EWJWF E4.0 OS/2 92F P EJOB COST SYSTEM 11FAA P EWPWF P EJOB COST SYSTEM 52F P Epage break 19F P EJOB STATUS REPORT 29F P Epassword protect yourF P EJOBMENU application 42F P Esystem 71F P EJOBSTAT 29F P EPFS:FILE 76FAA P EWLWF EPRG 60F P ELBG 60F EProfessional CompilerF P ELBL 60F E61F P ELBO 60F EPROGRAMMING 1F P Elicensing 41F Eprogramming 37F P Elinkage 11F EPROGRAMMING FORF P ELKSYS() 73F ENETWORKS 70F P ELocal Area NetworkF EPROGRAMMING UTILITIESF P ETechnology 92F E59F P Elocal area networks 70F EPROGRAMMING WINDOWSF P ELocking Techniques 73F EAND MENUS 42F P Elocks 73F EProtect 71F P ELOGICAL 79FAA P EWQWF P ELotus 76F P EQBE 60F P ELotus 123 76F P EQBO 60FAA P EWMWF EQUERIES 3F P EMainframes 76F EQuicksilver 67 PEAA ╔═╦═╗ ╔═╦═╗F P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F P E╚═╩═╝ ╚═╩═╝F P EWRWF ESQL Commands 80F P ERapidFile 76F EStep IVward 67F P ERELATED FILES 3F Esubtotal 19F P EREPORT 42F ESummary 20F P EReport Design 19F Esummary 38F P Ereport writer 19F ESYLK 76F P EREPORTING 1F ESYLK-Multiplan 76F P EReports Panel 19FAA P EWTWF P EROLLBACK 74F P ETable 79F P ERow 79F P ETemplate Language 58F P Eroyalties 41F P ETemplates 58F P ERoyalty FreeF P Etext editor 63F P EDistribution 61F P EThe Golden Rule 39F P ERuntime 41, 61F P ETIME SLIP INFORMATIONF P Eruntime/compiler 41F P EFORM 34FAA P EWSWF ETitle 19F P ESCR 60F ETransaction ProcessingF P EScreen Refresh 73F E73F P ESDF 78F ETYPE SDF 78F P Esecurity 59FAA P EWUWF P EServer Technology 92F P EunauthorizedF P ESET EXCLUSIVE OFF 73F P Emodification 59F P ESET TRAP ON 66F P EUPD 60F P ESMALLINT 79F P EUSE 2F P ESource 59FAA P ESPEED 37F EWVWF P ESQL - STRUCTURED QUERYF EValidation 32F P ELANGUAGE 79F EVisiCalc 76F P ESQL and dBASE IVFAA P EWWWF P EProgramming 82F P EWord Processors 76 @